Re: setting utf8 in my.cnf..

[Tetsuro Ikeda]

Pedro Han wrote:
> Dear Tetsuro Ikeda,
>
> Thanks a lot.
>
> But it says this;
>
> mysql would have been started with the following
> arguments:
> --port=3306 --socket=mysql
> --default-character-set=utf8
> --default-character-set=
> utf8 --no-auto-rehash
>
> mysql> show variables like "%character%";show
> variables like "%collation%";
> +--------------------------+----------------------
> ----------+
> | Variable_name | Value
> |
> +--------------------------+----------------------
> ----------+
> | character_set_client | utf8
> |
> | character_set_connection | utf8
> |
> | character_set_database | latin1
> |
> | character_set_results | utf8
> |
> | character_set_server | latin1
> |
> | character_set_system | utf8
> |
> | character_sets_dir |
> L:\xampp\mysql\share\charsets/ |
> +--------------------------+----------------------
> ----------+
> 7 rows in set (0.01 sec)
>
> +----------------------+-------------------+
> | Variable_name | Value |
> +----------------------+-------------------+
> | collation_connection | utf8_general_ci |
> | collation_database | latin1_swedish_ci |
> | collation_server | latin1_swedish_ci |
> +----------------------+-------------------+
>
> What's next?

Pedro,

What are doing with your server's charset setting?
I saw your server had set utf8 at your first post.

Generally, for using non-latin1 characters, we need to make sure 3 things.

1. table is set the charset. even if your character_set_database or character_set_server
is latin1, you can make non-latin1 table like followings:

mysql> CREATE TABLE t1 (c1 char(10)) DEFAULT CHARACTER SET = utf8;

2. character_set_client and character_set_connection are set to the non-latin1 charset
This affect when you insert or update row, and making sure your data is correctly
stored in the table.

3. character_set_results is set the the non-latin1 charset or NULL.
This affect when you select the data from the table.

No2 and 3 are usually achived by "SET NAMES" directly, or setting to the clients (include
connector products) like this time.

So Anyway, you already set up, I think.

Cheers,
-- Tetsuro