MySQL character_set_server won't take effect -
MySQL character_set_server won't take effect -
i'm trying have mysql server utilize utf8 default collation , character set. able set except character_set_server
takes latin1
value.
i have set 'character-set-server=utf8' in my.cnf, when run show variables character_set_server
, latin1.
if bring me help appreciated.
btw: i'm running mysql 5.6.19 on macos 10.9
thanks
please, seek alter character set of table :
mysql> set global character_set_server=utf8; mysql> set session character_set_server=utf8;
and alter table charcter set:
mysql> alter table test_latin1 default charset utf8;
mysql
Comments
Post a Comment