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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 11:36 PM
Subject: Re: this is WEAK!
> At 15:06 -0600 11/27/02, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
