At 15:06 -0600 11/27/02, johnt@stripped wrote:
>member varchar(16) NOT NULL default '',
>PRIMARY KEY (member),
Huh. That is weird, then. What does LENGTH(contact) return?
>
>
>On Wed, Nov 27, 2002 at 03:28:15PM -0600, Paul DuBois wrote:
>> At 14:48 -0600 11/27/02, johnt@stripped wrote:
>> >Why? (Note the extra space after "me" in the second select)
>>
>> Hardly enough information to go on. Apparently you're using a
>> column type like BLOB or TEXT for which trailing spaces are not
>> removed?
>>
>> >
>> >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)
