Home >Database >Mysql Tutorial >修改MySQL的字符编码_MySQL

修改MySQL的字符编码_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:41:10850browse

bitsCN.com
修改MySQL的字符编码 第一种方法:打开安装目录下的my.ini修改default-character-set=utf8的值 (UTF-8,GBK支持中文),在dos环境下登陆MySQL,如下图可验证字符编码已改变: 
修改MySQL的字符编码_MySQL
 第二种方法:直接在dos环境用sql语句修改,如图:
修改MySQL的字符编码_MySQL
 ps:linux系统和windows系统同理。 bitsCN.com

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn