Skip to content
This repository has been archived by the owner on Jun 16, 2021. It is now read-only.

关于#88 数据库编码影响排序结果的疑问 #108

Closed
KingOfXi opened this issue Jun 5, 2021 · 1 comment
Closed

关于#88 数据库编码影响排序结果的疑问 #108

KingOfXi opened this issue Jun 5, 2021 · 1 comment
Labels
Answered Answered questions

Comments

@KingOfXi
Copy link

KingOfXi commented Jun 5, 2021

我也出现了同样的问题,但我数据库应该已经使用UTF-8编码了,‘中英’<‘英文’依然是False。
20210605231507
20210605231600
首先可以看到各个数据库的编码都是UTF-8
20210605231642
但‘中英’<‘英文’依然是False。
真的如#88 所说是UTF-8编码问题吗?

@NewbieOrange
Copy link
Owner

NewbieOrange commented Jun 5, 2021

请在创建库(database)时将encoding设置为'UTF8',lc_collate设置为'en_US.UTF8'。

@NewbieOrange NewbieOrange added Question User questions Answered Answered questions labels Jun 5, 2021
@NewbieOrange NewbieOrange pinned this issue Jun 5, 2021
@NewbieOrange NewbieOrange removed the Question User questions label Jun 10, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Answered Answered questions
Projects
None yet
Development

No branches or pull requests

2 participants