Re: case sensitivity problem
Posted by: Peter Gulutzan
Date: May 15, 2006 01:37PM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
2532
November 30, 2005 05:07PM
Re: case sensitivity problem
1733
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.