set names latin1; drop table if exists t0; create table t0 (id int not null auto_increment primary key, foo enum('a','b','ö') default 'ö'); insert into t0 values ('','a'),('','b'),('','ö');