Thanks a lot! it works fine, but how to create index for a characterset

[shengw1127]

Thanks a lot! all it works fine!

but it seems a little slowly, so i want to create index for it. how to create the index for specified charset?

sql like that:
select id, name_cn, name_en from gen_city order by Convert('name_cn' USING gbk);