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
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
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 = \
>
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