MySQL sorting query based on Chinese pinyin

For example, there is now a data table label, field ID, name, and the character set for this table is gb2312 to Gb2312_chinese_ci.

Setting the InnoDB engine's character set is also simplified Chinese, and is organized into GB2312_CHINESE_CI.

The query statements are as follows:

Select *  from label order_by name collate gb2312_chinese_ci;

The effect is as follows:

Tip: Sometimes the result is not very accurate, do not know is because the character set selection of improper result, know the friend, please answer, thank you!