Re: [PHP-DB] Case sensitive search

2004-07-18 Thread Doug Thompson
Rosen wrote: Hi, I have a simple table: test ( id int unsigned NOT NULL auto_increment, data varchar(30) default NULL, PRIMARY KEY (id)) with two simple records: id data 1 "a" 2 "A" When I perform "select * from test where data='a' " - it return me both rows. http://dev.mysq

[PHP-DB] Case sensitive search

2004-07-18 Thread Rosen
Hi, I have a simple table: test ( id int unsigned NOT NULL auto_increment, data varchar(30) default NULL, PRIMARY KEY (id)) with two simple records: id data 1 "a" 2 "A" When I perform "select * from test where data='a' " - it return me both rows. By default in MySQL comp