gpt4 book ai didi

mysql - 更改默认排序规则/字符集

转载 作者:行者123 更新时间:2023-11-29 04:47:48 31 4
gpt4 key购买 nike

我知道之前已经回答过这个问题,但我发现的解决方案不适用于我的系统(我已经测试过了)。

我想更改 Mysql 中的默认排序规则。这似乎设置为 latin1_swedish_ci,我想将其更改为 UTF8_general_ci。

网络上最常返回的解决方案是将 default_character_set 指令放入 my.ini 中,默认值为 utf8,但由于某种原因它会出错。

这是错误。我希望有人能帮助我。

130502 15:45:17 [Note] Plugin 'FEDERATED' is disabled.
130502 15:45:17 InnoDB: The InnoDB memory heap is disabled
130502 15:45:17 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130502 15:45:17 InnoDB: Compressed tables use zlib 1.2.3
130502 15:45:17 InnoDB: Initializing buffer pool, size = 128.0M
130502 15:45:17 InnoDB: Completed initialization of buffer pool
130502 15:45:17 InnoDB: highest supported file format is Barracuda.
130502 15:45:17 InnoDB: Waiting for the background threads to start
130502 15:45:18 InnoDB: 1.1.8 started; log sequence number 2472751
130502 15:45:18 [ERROR] wampmysqld: unknown variable 'default-character-set=utf8'
130502 15:45:18 [ERROR] Aborting

130502 15:45:18 InnoDB: Starting shutdown...
130502 15:45:19 InnoDB: Shutdown completed; log sequence number 2472751
130502 15:45:19 [Note] wampmysqld: Shutdown complete

最佳答案

尝试:

character-set-server = utf8
collation-server = utf8_general_ci

关于mysql - 更改默认排序规则/字符集,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/16339922/

31 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com