CREATE TABLE `aleppo1phrase` ( `phrase` varchar(255) collate utf8_unicode_ci NOT NULL, `count` int(11) NOT NULL, PRIMARY KEY (`phrase`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; insert into aleppo1phrase values('{ס}',1),('{פ}',2),('שיא',3),('לא',4),('רשא',5),('תא',6),('תיב',7),('ןב',8),('ינב',9); select count,phrase,hex(phrase),hex(convert (phrase using utf8)),hex(convert(phrase using hebrew)) from aleppo1phrase where count > 0 order by hex(phrase);