case sensitivity problem
Posted by: Jonathan Nordell
Date: November 30, 2005 05:07PM

I'm having a problem with executing queries and them being case sensitive. I've read through about 20 google page results and searched through these forums, but I can't find anything that helps. I have a table users with a varchar column "name". In this table there is a user name "Paul". If I do a "select * from users where name = 'paul'" or select * from users where name like 'pau%'" I do not get any results. The only way I can get results returned is if I use case matching the value in the table. Everything I've read says this shouldn't be happening. What am I missing???

MySQL 4.1 installed on XP SP2

Variable Session value Global value
character set client utf8 utf8
character set connection utf8 utf8
character set database utf8 utf8
character set results utf8 utf8
character set server utf8 utf8
character set system utf8 utf8
collation connection utf8_general_ci utf8_general_ci
collation database utf8_general_ci utf8_general_ci
collation server utf8_general_ci utf8_general_ci

Options: ReplyQuote

Written By
case sensitivity problem
November 30, 2005 05:07PM
May 15, 2006 01:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.