[CentOS] Using UTF8 under mysql in Centos6

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