List:General Discussion« Previous MessageNext Message »
From:Pooly Date:June 29 2008 9:52pm
Subject:convertion to utf-8
View as plain text  
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,
Thread
convertion to utf-8Pooly29 Jun
  • Re: convertion to utf-8Dan Nelson30 Jun
    • Re: convertion to utf-8Pooly30 Jun
      • Re: convertion to utf-8Dan Nelson1 Jul
        • Re: convertion to utf-8Pooly3 Jul
  • RE: convertion to utf-8Jerry Schwartz30 Jun