set names utf8; set collation_connection='utf8_slovenian_ci'; DROP TABLE IF EXISTS `_tmp`; CREATE TABLE IF NOT EXISTS `_tmp` ( `term` varchar(400) COLLATE utf8_slovenian_ci DEFAULT NULL, KEY `Index 1` (`term`(333)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci; DELETE FROM `_tmp`; INSERT INTO `_tmp` (`term`) VALUES ('Meloe'), ('Méloé'); select * from _tmp where term = 'Meloe';