Re: Re[2]: binary varchar fields seems non-binary

2001-12-28 Thread Doug Thompson
BSi; Yes, you are correct. I think you found an important behavior in MySQL. Whether it is a bug or a feature depends on what the developers choose to do. If they revise the manual, it must be a feature. ;-) I think MySQL evaluates your original SELECT statements like a 'short-circuit OR': As

Re: binary varchar fields seems non-binary

2001-12-26 Thread Doug Thompson
It works the way you want with this data when your query is written: SELECT nev FROM hosoktest WHERE nev = ('pokember' OR 'Pokember'); Regards, Doug On Thu, 27 Dec 2001 01:33:57 +0100, Barnabas BONA wrote: >If I execute the following select: > SELECT nev FROM hosoktest WHER

Re: binary varchar fields seems non-binary

2001-12-26 Thread Bogdan Stancescu
Just my two cents: have you tried the following? SELECT nev FROM hosoktest WHERE (nev = 'Pokember') OR (nev = \ 'pokember'); Bogdan Barnabas BONA wrote: > If I execute the following select: >SELECT nev FROM hosoktest WHERE nev = 'pokember' OR nev = \ >

binary varchar fields seems non-binary

2001-12-26 Thread Barnabas BONA
With the dumpfile attached at the end of the message you can simply repeat it. Fix: Hope you know! Submitter-Id: Originator:[EMAIL PROTECTED] Organization: Hosemberkepzo MySQL support: none Synopsis: binary varchar fields seems non-binary Severity: serious Priority