如何更改 mysql 设置，使其默认为 UTF-8？

发布于 2024-08-31 20:56:23 字数 244 浏览 2 评论 0原文

当我插入数据库时，我收到“ASCII 编码”错误，因为我全新安装了 MYSQL。

我想再次将默认值更改为 UTF-8。

这是我收到的错误，因为 MYSQL 未设置为 UTF-8 模式：

UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-1: ordinal not in range(128)

原文

I am getting "ASCII encoding" errors when I insert into my database because I did a fresh install of the MYSQL.

I'd like to change the default to UTF-8 again.

This is the error I'm getting because MYSQL is not set in UTF-8 mode:

UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-1: ordinal not in range(128)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

苏大泽ㄣ 2024-09-07 20:56:23

您可以尝试将其放入 mysql.cfg 文件中：

[mysqld]  
port = 3306 
socket = mysql 
skip-locking 
init_connect='SET collation_connection = utf8_general_ci' 
init_connect='SET NAMES utf8' 
default-character-set=utf8 
character-set-server = utf8 
collation-server = utf8_general_ci 
[mysql] 
default-character-set=utf8

更多信息：

You can try to put this in your mysql.cfg file:

[mysqld]  
port = 3306 
socket = mysql 
skip-locking 
init_connect='SET collation_connection = utf8_general_ci' 
init_connect='SET NAMES utf8' 
default-character-set=utf8 
character-set-server = utf8 
collation-server = utf8_general_ci 
[mysql] 
default-character-set=utf8

More information:

回复收藏 0 原文

~没有更多了~