List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 27 2002 10:02pm
Subject:Re: this is WEAK!
View as plain text  
In the last episode (Nov 27), johnt@stripped 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
	dnelson@stripped
Thread
this is WEAK!johnt27 Nov
  • Re: this is WEAK!Paul DuBois27 Nov
    • Re: this is WEAK!johnt27 Nov
      • Re: this is WEAK!Paul DuBois27 Nov
        • Re: this is WEAK!johnt27 Nov
      • Re: this is WEAK!Paul DuBois27 Nov
  • Re: this is WEAK!Dan Nelson27 Nov
    • Re: this is WEAK!johnt27 Nov
  • Re: this is WEAK!Chris Knipe27 Nov