binary select - case sensitive

hi all... i found this on the mysql dev manual site: MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison. so here i tried it but no good. any ideas?! the field is not declared binary but i do

Re: binary select - case sensitive

kalin mintchev wrote: hi all... i found this on the mysql dev manual site: MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison. so here i tried it but no good. any ideas?! the field is not

Re: binary select - case sensitive

http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html It has some good examples. got it thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]