MySQL Forums
Forum List  »  Newbie

Converting from charset latin1 to utf8 and getting "Duplicate entry X for key..." errors
Posted by: Keith Palmer Jr.
Date: February 20, 2009 08:39AM

So I'm converting a database from a latin1 charset to utf8, and I end up getting errors like this one:

ALTER TABLE tablename CHANGE `alias` `alias` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;

MySQL said:
#1062 - Duplicate entry 'M' for key 'alias'


Is there something else I should be doing to avoid these errors? Or a clever way to get around this?

Options: ReplyQuote


Subject
Written By
Posted
Converting from charset latin1 to utf8 and getting "Duplicate entry X for key..." errors
February 20, 2009 08:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.