Re: Case sensitive search

Hi, i suggest you to use the LIKE operator instead of the relational operator. Rui Cunha Rosen writes:

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 comparing of strings is case-insensitive. How can I perform a case sensitive search in text fields ? Tnanks in advance, Rosen

*************************************

* Rui Pedro Cunha                   *

* Dpto. de Ciências e Tecnologias * * Universidade Autónoma de Lisboa *

* Rua de Santa Marta, 56,           *
* 1169-023 Lisboa                   *

* Telefone (+351) 21 317 76 35/49 *

* Fax       (+351) 21 353 37 02     *
* Url : http://www.ual.pt/dct/      *
* E-mail: rui.cunha@ual.pt          *
*************************************