***BOGO*** RE: convertion to utf-8

["Jerry Schwartz" <jschwartz@xxxxxxxxxxxxxxxx>]

>-----Original Message-----
>From: Pooly [mailto:pooly7@xxxxxxxxx]
>Sent: Sunday, June 29, 2008 5:52 PM
>To: mysql@xxxxxxxxxxxxxxx
>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/mysql?unsub=jschwartz@the-
>infoshop.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx