mysql 對utf8編碼 中文排序

SELECT * FROM `m` order by   convert(name using gbk) asc;

eg:

select DISTINCT(b.id),b.ach_name,b.ach_bussiness,b.ach_finish_date,b.ach_finish_unit ,m.areaid,a.areaname from 
(
select id,ach_name,thumb,ach_bussiness,ach_finish_unit,ach_entrust_unit,ach_finish_date,user_id,ach_delivery_type,ach_inn_small_classid,rtime  from 
 ac_achievement where is_pass=1  limit 0,10
) b,ac_member m,ac_area a 
where b.user_id = m.userid and m.areaid=a.areaid
order by  convert(a.areaname using gbk) desc