set names utf8; create table t1 (a varchar(30) not null primary key) default character set utf8 collate utf8_general_ci engine=ibmdb2i; insert into t1 values ('あいうえおかきくけこさしすせそ'); insert into t1 values ('さしすせそかきくけこあいうえお'); select a as gci1 from t1 where a like 'さしすせそかきくけこあいうえお%'; select a as gci2 from t1 where a like 'あいうえおかきくけこさしすせそ'; drop table t1;