In the last episode (Nov 27), [EMAIL PROTECTED] said: > Why? (Note the extra space after "me" in the second select) > > Your MySQL connection id is 6021 to server version: 3.23.41-log > > mysql> select contact from options where member='me'; > +---------+ > | contact | > +---------+ > | me | > +---------+ > 1 row in set (0.00 sec) > > mysql> select contact from options where member='me '; > +---------+ > | contact | > +---------+ > | me | > +---------+ > 1 row in set (0.00 sec)
>From http://www.mysql.com/doc/en/Bugs.html: * All string columns, except BLOB and TEXT columns, automatically have all trailing spaces removed when retrieved. For CHAR types this is okay, and may be regarded as a feature according to ANSI SQL92. The bug is that in MySQL Server, VARCHAR columns are treated the same way. It's also mentioned in http://www.mysql.com/doc/en/Differences_from_ANSI.html . -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php