Re: utf8 charset comunication PHP5 -> MySQL4.1 IMPOSSIBLE!

[Shuichi Tamagawa]

Hi

> I have changed EVERYTHING to utf-8 charset:

<cut>

> [mysql]
>default-character-set=utf8

</cut>

This works only for 'mysql' command line client in bin directory, and does not work for the client library that your PHP program use.

Check the result of 'SHOW VARIABLES LIKE 'char%' from your program. The value of the client character set variables such as:

character_set_client
character_set_connection
character_set_results

would be 'latin1' because the default character set of the client library is 'latin1' unless you compile it from source using '--with-charset=character_set_name'.

To change the character set of the client library, you can do one of the followings:

1. execute 'SET NAMES utf8' everytime after connecting to the database
2. add init_connect='SET NAMES utf8' in [mysqld] part of my.cnf
3. compile mysql from source using --with-charset=utf8 and have your PHP to use the client library.

Hope it helps.

Regards,

Shu