drop table if exists t;
set names ujis;
set character_set_database = ucs2;
#this is to avoid 'illegal mix of collation' error 
set collation_connection = ucs2_general_ci;
#create table that has enum column with half-with katakana
create table t(a enum('Ž±','Ž²','Ž³'), index(a)) default charset = ucs2;
#insert the half-with katakana data
insert into t values ('Ž±'),('Ž²'),('Ž³');