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

Popular posts from this blog

php - Android app custom user registration and login with cookie using facebook sdk -

django - Access session in user model .save() -

php - .htaccess Multiple Rewrite Rules / Prioritizing -