List:General Discussion« Previous MessageNext Message »
From:johnt Date:November 27 2002 9:39pm
Subject:Re: this is WEAK!
View as plain text  
mysql> select LENGTH(contact) from options where member='me ';
+-----------------+
| LENGTH(contact) |
+-----------------+
|               2 |
+-----------------+
1 row in set (0.01 sec)


On Wed, Nov 27, 2002 at 03:36:03PM -0600, Paul DuBois wrote:
> 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