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.

Sign up for GitHub

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

Jump to bottom

utf8 & utf8mb4编码问题 #279

Open
ryeLearnMore opened this issue Dec 18, 2024 · 5 comments
Open

utf8 & utf8mb4编码问题 #279

ryeLearnMore opened this issue Dec 18, 2024 · 5 comments

Comments

@ryeLearnMore
Copy link

客户端/代码通过gaea连接数据库会报错：Query Brror (5041) unsupport charset SQL [SET NAMES 'utf8mb4' COLLATB 'utf8mb4_general_ci'。但是如果直接连接数据库没有任何编码问题，请问这个是什么原因？gaea需要怎么设置可以规避这个问题？
@github-actions GitHub Actions
Copy link

Thank you for raising an issue. We will try and get back to you as soon as possible. Please make sure you have given us as much context as possible.

@xiyangxixian
Copy link
Contributor

xiyangxixian commented Dec 30, 2024 •
edited
Loading

请问一下这个是用的哪个版本呢？
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 这个 Gaea 应该是支持的

@ryeLearnMore
Copy link
Author

请问一下这个是用的哪个版本呢？ SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 这个 Gaea 应该是支持的

v1.2.5版本

@xiyangxixian
Copy link
Contributor

SET NAMES 'utf8mb4' COLLATB 'utf8mb4_general_ci 这个 COLLATB 是否是输入有误呢 应该是 COLLATE

@ryeLearnMore
Copy link
Author

utf8mb4_general_ci

sorry，是我输入错误，是：COLLATE

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@xiyangxixian @ryeLearnMore