在linux SHELL中输入mysql会有类似mysql无法识别OS Characterset GB18030,
mysql: Unknown OS character set'GB18030'.
mysql: Switching to the default character set'latin1'.
mysql: Unknown OS character set 'GB18030'.
mysql: Switching to the default character set 'latin1'.
采用默认的latin1之类的信息,表明操作系统的编码设置需要修改,描述如下:
查看操作系统的字符集
#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=
#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
#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"
设置完成后,
#source /etc/profile
#source /etc/profile
使环境变量生效,如果不放心,可以reboot
分享到:
2012-05-04 11:02
浏览 13602
分类:数据库
评论