自由飞翔

我在仰望,java之上

统计

留言簿(2)

我关注的blog

阅读排行榜

评论排行榜

mysql设置编码格式

ALTER DATABASE `databasename` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE `tableName` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE `tableName` CHANGE `dd` `dd` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
create table()ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='哈喽啦'
show variables like 'collation_%';
SHOW VARIABLES LIKE 'character%';
SET character_set_client = utf8 ; 
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set character_set_system = utf8;

set collation_connection='utf8_general_ci';
set collation_database=
'utf8_general_ci';
set collation_server='utf8_general_ci';


Gavin

posted on 2011-12-01 21:52 GavinMiao 阅读(920) 评论(0)  编辑  收藏 所属分类: mysql


只有注册用户登录后才能发表评论。


网站导航: