Re: case sensitivity problem

[Peter Gulutzan]

Maybe the column collation is case sensitive. Try
SHOW CREATE TABLE users;
I know that it works for me with MySQL 5.0:

mysql> create table t (name varchar(20) character set utf8 collate utf8_general_ci);
Query OK, 0 rows affected (0.05 sec)

mysql> insert into t values ('paul'),('Paul');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> select * from t where name = 'paul';
+------+
| name |
+------+
| paul |
| Paul |
+------+
2 rows in set (0.00 sec)