rendered paste bodymysql> 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
+--------------------------------------------------+--------------------------+---------------------+