mysql数据库需改默认字符编码

落日映苍穹つ 2023-10-17 13:32 51阅读 0赞

以下配置指配置文件my.ini：

**\[plain\]** [view plain][] [copy][view plain]

1.  \[mysqld\] 
2.  
3.  character\_set\_server=utf8 
4.  collation-server=utf8\_general\_ci 
5.  
6.  ...... 
7.  
8.  \[client\] 
9.  \#设置客户端字符集 
10. default-character-set=utf8

然后重启服务器，编码配置即更改，注意位置，default-character-set=utf8只能放在\[client\]下面，否则不能启动[MySQL][]

下面给出一个示例（仅供参考）:

**\[plain\]** [view plain][] [copy][view plain]

1.  \# For advice on how to change settings please see 
2.  \# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html 
3.  \# \*\*\* DO NOT EDIT THIS FILE. It's a template which will be copied to the 
4.  \# \*\*\* default location during install, and will be replaced if you 
5.  \# \*\*\* upgrade to a newer version of MySQL. 
6.  
7.  \[mysqld\] 
8.  
9.  \# Remove leading \# and set to the amount of RAM for the most important data 
10. \# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 
11. \# innodb\_buffer\_pool\_size = 128M 
12. 
13. \# Remove leading \# to turn on a very important data integrity option: logging 
14. \# changes to the binary log between backups. 
15. \# log\_bin 
16. 
17. \# These are commonly set, remove the \# and set as required. 
18. \# basedir = ..... 
19. \# datadir = ..... 
20. \# port = ..... 
21. \# server\_id = ..... 
22. 
23. \#skip-grant-tables 
24. \#设置字符集为utf8 
25. character\_set\_server=utf8 
26. collation-server=utf8\_general\_ci 
27. loose-default-character-set = utf8 
28. basedir = D:/Java/mysql5.6 
29. datadir = D:/Java/mysql5.6/data 
30. 
31. \[client\] 
32. \#设置客户端字符集 
33. default-character-set=utf8 
34. loose-default-character-set = utf8 
35. 
36. \[WinMySQLadmin\] 
37. Server = D:/Java/mysql5.6/bin/mysqld.exe 
38. 
39. 
40. \# Remove leading \# to set options mainly useful for reporting servers. 
41. \# The server defaults are faster for transactions and fast SELECTs. 
42. \# Adjust sizes as needed, experiment to find the optimal values. 
43. \# join\_buffer\_size = 128M 
44. \# sort\_buffer\_size = 2M 
45. \# read\_rnd\_buffer\_size = 2M 
46. 
47. sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

[view plain]: http://blog.csdn.net/liudingabcde/article/details/18826371#
[MySQL]: http://lib.csdn.net/base/mysql