At 11:01 PM -0600 1/20/01, Andrei Zmievski wrote:
>At 06:34 PM 1/20/01 -0800, Jeremy D. Zawodny wrote:
>>MySQL does trailing whitespace removal on all VARCHAR data as
>>described in the manual.
>
>Hmm, well that presents a problem in my application that counts on
>exact comparisons - I guess a wa
At 06:34 PM 1/20/01 -0800, Jeremy D. Zawodny wrote:
>MySQL does trailing whitespace removal on all VARCHAR data as
>described in the manual.
Hmm, well that presents a problem in my application that counts on exact
comparisons - I guess a way to do it is to use 'like' instead of '='?
-Andrei
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
Hi,
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 ligh
