On Mon, Jun 4, 2012 at 11:53 AM, David Hrbáč david-lists@hrbac.cz wrote:

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áč

Uhmm .. and nothing more?? The only difference with my config is the underscore ...

On Mon, Jun 4, 2012 at 1:02 PM, David Hrbáč david-lists@hrbac.cz wrote:

Dne 4.6.2012 12:22, C. L. Martinez napsal(a):

...

Uhmm .. and nothing more?? The only difference with my config is the underscore ...

Yes, that's all, works pretty well. It's a little bit different than on C5, here we use only: default-character-set=utf8 init_connect='SET NAMES utf8' David Hrbáč

Ok, I will try it ... many thanks.

On Mon, Jun 4, 2012 at 12:56 PM, Dennis Jacobfeuerborn dennisml@conversis.de wrote:

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?

mysql> show variables like 'char%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec)