case sensitivity problem

[Jonathan Nordell]

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???

Installation:
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