Sorting of Chinese Field (order by Chinese)

SELECT * FROM 資料表 ORDER BY CONVERT([Field Name] USING BIG5)

Laravel example:

    static function cities(){
        $result = self::select('city')
            ->distinct()
            ->orderBy(DB::raw('convert(city using big5')))
            ->get();
        return $result;
    }