On Mon, Jun 4, 2012 at 12:56 PM, Dennis Jacobfeuerborn <dennisml at 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)