根据字母首字母排序

mongodb中文排序
 db.getCollection("xxx").find().collation({locale:'zh@collation=gb2312han'}).sort({name:1})
 mysql中文排序
 SELECT brand_id, brand_name FROM table_name ORDER BY convert(filed_name using gbk) ASC;