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, [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
