Select * from tablenameorder by username collate chinese_prc_stroke_ci_as Note that the columns used later ORDER BY can only be char, varchar, nchar, nvarchar data type
