All we have to change in my.cnf file, adding content below:

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
init-connect='SET NAMES utf8'

After configuring those parameters, restart your mysql database and now:
show variables like '%char%';
will give you a satisfactory feedback!



Published

28 September 2013

Category

operation

Tags