mysql没法识别OS Characterset GB18030的处理
mysql无法识别OS Characterset GB18030的处理
在linux SHELL中输入mysql会有类似mysql无法识别OS Characterset GB18030,
- mysql: Switching to the default character set 'latin1'.
mysql: Unknown OS character set 'GB18030'. mysql: Switching to the default character set 'latin1'.
采用默认的latin1之类的信息,表明操作系统的编码设置需要修改,描述如下:
查看操作系统的字符集
- LANG=utf8
- LC_CTYPE="utf8"
- LC_NUMERIC="utf8"
- LC_TIME="utf8"
- LC_COLLATE="utf8"
- LC_MONETARY="utf8"
- LC_MESSAGES="utf8"
- LC_PAPER="utf8"
- LC_NAME="utf8"
- LC_ADDRESS="utf8"
- LC_TELEPHONE="utf8"
- LC_MEASUREMENT="utf8"
- LC_IDENTIFICATION="utf8"
- LC_ALL=
#locale LANG=utf8 LC_CTYPE="utf8" LC_NUMERIC="utf8" LC_TIME="utf8" LC_COLLATE="utf8" LC_MONETARY="utf8" LC_MESSAGES="utf8" LC_PAPER="utf8" LC_NAME="utf8" LC_ADDRESS="utf8" LC_TELEPHONE="utf8" LC_MEASUREMENT="utf8" LC_IDENTIFICATION="utf8" LC_ALL=
如果不是这样,则需要对操作系统字符集进行修改:
#vim /etc/syconfig/i18n
修改成:LANG="zh_CN.UTF-8"即可
另外,再查看一下环境变量的设置
- #vim /etc/profile
#vim /etc/profile
里面可以没有字符集的设置,如果有,应类似如下设置:
写道
export LC_ALL="C"
#export LANG="zh_CN.UTF-8"
#export LANG="zh_CN.UTF-8"
设置完成后,
#source /etc/profile
使环境变量生效,如果不放心,可以reboot