--查看數(shù)據(jù)庫(kù)的字符集
show variables like 'character\_set\_%';
show variables like 'collation_%';
--設(shè)置數(shù)據(jù)庫(kù)字符編碼
set names GBK
alter database payment character set GBK;
create database mydb character set GBK;
set character_set_client=gbk;
set character_set_connection=gbk;
set character_set_database=gbk;
set character_set_results=gbk;
set character_set_server=gbk;
set character_set_system=gbk;
set collation_connection=gbk;
set collation_database=gbk;
set collation_server=gbk;
posted on 2008-11-25 13:26
一凡 閱讀(680)
評(píng)論(0) 編輯 收藏 所屬分類(lèi):
DATABASE