List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:November 27 2002 10:49pm
Subject:Re: this is WEAK!
View as plain text  
where member='me ' is not the same as where member='me' ('me ' != 'me')

I've noticed this as well with just about any mysql version, on any
platform.....

The tables / columns really isn't important here IMHO... From what I can
see, trailing spaces are always droped, which shouldn't be.



----- Original Message -----
From: "Paul DuBois" <paul@stripped>
To: <johnt@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, November 27, 2002 11:36 PM
Subject: Re: this is WEAK!


> 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)
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread126007@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-savage=savage.za.org@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

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