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]

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

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