|
|
修改mysql安裝目錄下的my.ini文件. 打開找到這一行:
 # The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
# [mysql] default-character-set=gbk mysql
再找到這一行:
# The default character set that will be used when a new schema or table is
# created and no character set is defined default-character-set=utf8
這個(gè)是創(chuàng)建數(shù)據(jù)庫或表時(shí)的默認(rèn)字符集,用utf8處理國際化
對于以前已經(jīng)創(chuàng)建好的非gbk字符的數(shù)據(jù)庫,在mysql的安裝下
的data目錄下,找到你建的相應(yīng)數(shù)據(jù)庫,進(jìn)去后找到db.opt文件
用記事本打開,內(nèi)容改成下面的即可.
default-character-set=utf8 default-collation=utf8 最好用utf8,
因?yàn)間bk在處理國際化的時(shí)候依然會(huì)亂碼. 最后一種方法,
你可能臨時(shí)需要設(shè)定字符編碼,而又不想改配置文件.
那在執(zhí)行創(chuàng)建腳本前,加入set names gbk(或utf8)即可.
比如: set names utf8; create table user(略);
|