java learnging

一塊探討JAVA的奧妙吧

posts - 34, comments - 27, trackbacks - 0, articles - 22

mysql常用操作

Posted on 2005-07-25 17:38 bigseal 閱讀(1440) 評(píng)論(0) 編輯收藏

修改默認(rèn)字符集（default character set）
在mysql的my.ini配置文件中設(shè)置，這樣在mysql啟動(dòng)后就會(huì)自動(dòng)加載
例如：把默認(rèn)字符集設(shè)置為UTF-8

default-character-set=utf8

查看變量值：
例如：查看字符集設(shè)置

SHOW VARIABLES LIKE 'character_set_%';

SHOW VARIABLES LIKE 'collation_%';

設(shè)置變量值
例如：設(shè)置字符集變量

set character_set_server = utf8;

set character_set_system = utf8;

set character_set_database = utf8;

set character_set_client = utf8;

set character_set_connection = utf8;

set character_set_results = utf8;

set collation_connection = utf8_general_ci;

set collation_database = utf8_general_ci;

set collation_server = utf8_general_ci;


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理