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 declared
binary but i do have 'binery' in my select. is it in the wrong place?!
Check the comments on this page:
http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html
It has some good examples.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
