List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 27 2002 9:36pm
Subject:Re: this is WEAK!
View as plain text  
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)

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