Resolved mysql upper lowercase name

[durangod]

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]

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/...binary-op.html

[Old Pedant]

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]

thank you both very much