...

View Full Version : Resolved mysql upper lowercase name



durangod
09-06-2011, 04:48 PM
I am having an issue with the query seeing upper and lower case named files as the same.

the server is fine it does allow me to add it to the directory either way and it does see it as different filenames.

but if i have a value in my table for example Widget and widget and i run a query on that, mysql sees both names as the same.

i have no strtolower or strtoupper in my script.

any suggestions? i need mysql to see Widget and widget as different values.

abduraooft
09-06-2011, 05:45 PM
but if i have a value in my table for example Widget and widget and i run a query on that, mysql sees both names as the same.


SELECT something from somewhere where BINARY filename='somename'
Check http://dev.mysql.com/doc/refman/5.0/en/charset-binary-op.html

Old Pedant
09-06-2011, 06:28 PM
FWIW, the ANSI SQL requirement is that text values are *supposed* to be case insensitive. Most DBs provide some way to override the default behavior. MySQL's use of BINARY happens to be one of the simplest.

durangod
09-06-2011, 09:05 PM
thank you both very much



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum