DROP TABLE IF EXISTS t1; set names latin1; create table t1 (s1 char(5) character set latin1); insert into t1 values ('æ'),('ø'),('å'); select s1,hex(s1),length(s1) from t1 order by s1; s1 hex(s1) length(s1) å E5 1 æ E6 1 ø F8 1