Re: [CentOS] Using UTF8 under mysql in Centos6

On 06/04/2012 11:44 AM, C. L. Martinez wrote:

Hi all,

I am trying to configure utf8 in mysql under centos6 to display special characters, like accents. I use this mysql instance to store plain syslog logs. I have configured this under my.cnf:

[mysqld] init_connect = 'SET collation_connection = utf8_general_ci' init_connect = 'SET NAMES utf8' character-set-server = utf8 collation-server = utf8_general_ci

[client] default-character-set = utf8

but it doesn't seems to work ... Any idea??

Did you make sure your database is using utf8 as well? What does "show variables like 'char%'" show?

Regards, Dennis