>-----Original Message----- >From: Pooly [mailto:[EMAIL PROTECTED] >Sent: Sunday, June 29, 2008 5:52 PM >To: mysql@lists.mysql.com >Subject: convertion to utf-8 > >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 > [JS] Try removing the unique key and then import the data. Take a look at what is actually being stored. I doubt that MySQL is lying, so you need to trace back to the source of the data, one step at a time. I've gone down this road, and learnt quite a lot about the data conversions that go on behind the scenes.
>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] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
