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?? Thanks.
Dne 4.6.2012 11:44, C. L. Martinez napsal(a):> 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?? > > Thanks. >Hi, On C6 we use these directives: init_connect='SET NAMES utf8' character_set_server = utf8 collation_server = utf8_general_ci David Hrb??
From: C. L. Martinez <carlopmart at gmail.com>> [mysqld] > init_connect = 'SET collation_connection = utf8_general_ci' > init_connect = 'SET NAMES utf8' > character-set-server = utf8 > collation-server = utf8_general_ci > but it doesn't seems to work ... Any idea??Ony difference from ours is: init_connect='set collation_connection = utf8_general_ci; set character set utf8;' JD
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