12 Dec
2005
12 Dec
'05
9:27 a.m.
Erik Petersen wrote: On 12/11/05 7:39 PM, "John Peacock" jpeacock@rowman.com wrote:
Searches in MySQL are not case sensitive:
http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html
True, WHERE 'FOO' like 'foo' is a match but my user_query is WHERE username = '%u'
SELECT 'Foo' = 'foo'
gives 1 (true) to me.
You have have to declare your columns as VARCHAR(..) BINARY. Then MySQL will do no case-folding whatsoever.
Best Regards, Michael Paesold