Tarhon-Onu Victor wrote: > Are cineva idee de ce boii de la mysql.org sint atit de boi >incit sa redefineasca relatia de egalitate intre 2 siruri? > >mysql> select * from ckt where c1='aaa'; >+------+ >| c1 | >+------+ >| aaa | >| AAA | >+------+ >2 rows in set (0.00 sec) > > > Chestia asta este documentata in manualul de MySQL la sectiunea MySQL Extensions to ANSI SQL92:
"All string comparisons are case insensitive by default, with sort ordering determined by the current character set (ISO-8859-1 Latin1 by default). If you don't like this, you should declare your columns with the |BINARY| attribute or use the |BINARY| cast, which causes comparisons to be done according to the ASCII order used on the MySQL server host." Deci nu este bug, e feature! ;-) -- Laurentiu Matei <[EMAIL PROTECTED]> Software Manager Simco International SRL [www.simcoint.com] Linux Registered User #270531
