[CentOS] Using UTF8 under mysql in Centos6

Mon Jun 4 10:59:24 UTC 2012
C. L. Martinez <carlopmart at gmail.com>

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)