On Sat, Jan 20, 2001 at 02:46:49PM -0600, Andrei Zmievski wrote:
> I recently ran into a problem when doing comparison against varchar
> field. Basically, comparing 'foo' and 'foo ' (note extra space)
> against the records produced the same results - almost as if MySQL
> trims the whitespace from the search parameter before running the
> search. Can anyone shed light on this issue? This is with the
> 3.23.30-gamma.
MySQL does trailing whitespace removal on all VARCHAR data as
described in the manual.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
