Hi, I'm trying to convert my tables to UTF8 but I'm getting the following error: ERROR 1062 (23000): Duplicate entry 'Zorglüb' for key 1
Not too sure why I'm getting this error since the current (latin1) data are: mysql> select * from topics_lookup where label like 'Zor%'; +----------+----------+------+ | label | topic_id | main | +----------+----------+------+ | Zorglub | 72 | 0 | | Zorglüb | 72 | 1 | +----------+----------+------+ 2 rows in set (0.00 sec) There is a unique index on label, however the 2 data are different. Any ideas ? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]