mysql> SHOW CREATE TABLE oldprogram \G *************************** 1. row *************************** Table: oldprogram Create Table: CREATE TABLE `oldprogram` ( `oldtitle` varbinary(128) NOT NULL default '', `airdate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`oldtitle`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) SELECT HEX(oldtitle), oldtitle, airdate FROM oldprogram WHERE oldtitle LIKE "Esp%Com%" OR oldtitle LIKE "ESP%COM%"; +------------------------------------------+----------------------+---------------------+ | HEX(oldtitle) | oldtitle | airdate | +------------------------------------------+----------------------+---------------------+ | 45535041C3914120454E20434F4D554E49444144 | ESPAƃA EN COMUNIDAD | 2008-03-17 13:35:00 | | 457370616E6120656E20436F6D756E69646164 | Espana en Comunidad | 2008-03-16 01:30:00 | +------------------------------------------+----------------------+---------------------+ 2 rows in set (0.00 sec) mysql> ALTER TABLE oldprogram MODIFY oldtitle varchar(128) CHARACTER SET utf8 NOT NULL default '';ERROR 1062 (23000): Duplicate entry 'Espana en Comunidad' for key 1 +--------------------------------------------------+--------------------------+---------------------+