On Sat, 5 Jul 2003, cosmin wrote:
> Mysql: Distrib 3.23.52
>
> create table persoana( nume varchar(30) );
> insert into persoana values('Dan'),('Luca'),('dan');
> delete from peroana where nume='Dan';
>
> de ce imi sterge si pe dan si pe Dan
>
> nu e case sensitive?
Hmmm, nu mai citeste nimeni documentatia in ultima vreme? Check this out:
http://www.mysql.com/doc/en/CHAR.html
=====================================
Values in CHAR and VARCHAR columns are sorted and compared in
case-insensitive fashion, unless the BINARY attribute was specified when
the table was created. The BINARY attribute means that column values are
sorted and compared in case-sensitive fashion according to the ASCII order
of the machine where the MySQL server is running. BINARY doesn't affect
how the column is stored or retrieved.
=====================================
A durat putin sub 5 secunde cautarea :-/
Numai bine,
--
Mihnea-Costin Grigore [ "Tenebus Ipsilo Ibinem Catehens" ]
E-mail: [EMAIL PROTECTED] Home Page: http://mgc8.virtualave.net
