[RESOLVED] uppercase

[vang]

hi,
i have a string in database: ADSasdf123.
i query databse with adsasdf123 and there is no problem.
i query databse with ADSASDF123 and there is no problem also.
My requirements need both the above 2 queries to give error which it doesn't..
it seems to me that the sql query cannot identify uppercase or lowercase characters.
How can i make it in such a way that the sql query can differentiate uppcase & lowercase characters?
thanks.

[laserlight]

You should state what database management system you are using (and also things like the version of PHP, your webserver software, and the database extension, though these are probably unnecessary in this case). My guess is that you are using MySQL, and if so read Case Sensitivity in String Searches.

[vang]

thank q so much.
i solve it by adding this COLLATE latin1_general_cs to the original sql statement and it works great🙂

[laserlight]

You're welcome. Remember to mark this thread as resolved (if it is) using the thread tools.