更改默认排序规则/字符集 [英] Change default collation/character set

问题描述

我知道以前已经回答过，但是我发现的解决方案不适用于我的系统(我已经对其进行了测试).

I know this has been answered before but the solutions I found does not apply to my system (I've tested them).

我想更改Mysql中的默认排序规则.看来这已设置为latin1_swedish_ci，我想将其更改为UTF8_general_ci.

I want to change the default collation in Mysql. It seems this is setted to latin1_swedish_ci and i want to change this to UTF8_general_ci.

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

The most frequently returning solution on the net was putting the default_character_set directive in my.ini with default value of utf8, but for some reason it gives an error.

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

this is the error. I hope someone can help me.

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

这篇关于更改默认排序规则/字符集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！