Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Err] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci' #4

Open
geekymv opened this issue Jun 15, 2019 · 1 comment
Open

[Err] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci' #4

geekymv opened this issue Jun 15, 2019 · 1 comment

Comments

@geekymv
Copy link

geekymv commented Jun 15, 2019

在mysql5.7.23 上执行docs/db/vole.sql 会报错[Err] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
查阅资料发现mysql8.0 开始默认的CHARSET改为utf8mb4,并且默认的COLLATE也改为了utf8mb4_0900_ai_ci,就想问下大家都已经开始使用mysql8了么?

@doudh
Copy link

doudh commented Oct 19, 2019

在mysql5.7.23 上执行docs/db/vole.sql 会报错[Err] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
查阅资料发现mysql8.0 开始默认的CHARSET改为utf8mb4,并且默认的COLLATE也改为了utf8mb4_0900_ai_ci,就想问下大家都已经开始使用mysql8了么?

我改了创建表的sql。数据库是5.7 类型为:utf8mb4_unicode_ci。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants