Good morning. I have a table with field name DATA type tinytext. The table is already populated. I need DATA to be unique. It seems that MySQL doesn't look at the uniqueness of a field in a binary fashion.
Example (chosen because I think it is just plain odd) june = Júne If I query as - Select * from myTable where DATA = 'june' - I am returned both. If I query as Select * from myTable where cast(DATA as binary) = 'june' - I am returned only one. How can I set this table so that the unique key is based on the binary value of the field? Do I have to alter the field type or is there a better way? Thank you. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. Microneil Research Sortmonster Anti Spam GOD BLESS AMERICA! To God Be The Glory! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
