Explore the database, Chinese field sorting, what is it

Problem description ： In the database , Sorting of Chinese fields , Ascending Descending , What is the competition behind ？

Tools used ：

mysql database ,jdk Self contained native2ascii.exe

say something native2ascii Tool use ：

It's installation jdk The self-contained encoding converter , After configuring the system environment variables , It can be called anywhere .

Open the command line , Input ：native2ascii enter   Chinese characters can be transferred unicode code .

Can also be .txt Wait for the text document to be converted to the specified code , There is no demonstration here .

Prepare a table , Some of the data

Just start , First try sorting by name

result , Zhang Hao was the first , Qin Si is at the end , It's not supposed to be sorted by pinyin or strokes

analysis ： Zhang Hao is in front of Zhang Fei , explain ‘ Hao ’ Greater than ‘ Not ’

verification ： The bottom layer is unicode Code size

So that's it ：

There is a problem in the extension ： Change the code of the database into gbk, Whether the sorting rule is satisfied , Still sort according to the size of the code

Create a new one gbk Coded database , Key list , insert data ：

Sort ： The order of discovery is different from the coding just now

verification ： Use online tools to get Chinese characters gbk code

http://mytju.com/classcode/tools/encode_gb2312.asp

Li C0EE LAN C0BC
Lin C1D6 thinking CBBC
The qin dynasty C7D8 3、 ... and C8FD

The qin dynasty C7D8 thinking CBBC
king CDF5 bright C3F7
Zhang D5C5 Not B7C7
Zhang D5C5 Hao F0A9

Conclusion ： Sort by Pinyin , The first word is the same as the second word , In turn ...

About gbk Specific sorting rules of coding , Interested , I write a blog alone