Get the App
SLTechnology News&Howtos  ›  Database  › 

Chinese sorting problem of character set utf8

Shulou Source: shulou.com Published: 2022-06-01 09:09:51 11月16日 Update

Database

Character set: utf8

Collation: utf8_generay_ci

Table structure:

Mysql > desc chr

+-+ +

| | Field | Type | Null | Key | Default | Extra | |

+-+ +

| | char_1 | char (255) | YES | | NULL |

| | bin | varbinary (20) | YES | | NULL |

| | name | varchar (50) | YES | | NULL |

| | static_bin | binary (30) | YES | | NULL |

+-+ +

Chinese sorting will be out of order:

Mysql > select * from chr order by name

+-+

| | char_1 | bin | name | static_bin | |

+-+

| | No |

| | he |

| | send Safin |

| | Ah |

| | A |

| | Uh, hungry |

+-+

6 rows in set (0.01 sec

Mysql > select * From chr order by convert (name using 'gbk') collate' gbk_chinese_ci'

->

+-+

| | char_1 | bin | name | static_bin | |

+-+

| | A |

| | Ah |

| | No |

| | Uh, hungry |

| | send Safin |

| | he |

+-+

6 rows in set (0.00 sec)

Mysql >

Tags: Safin sort character character set Chinese data database structure rules problems Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Shulou Tech Info Shulou Technology Shulou Information Docker