setting utf8 in my.cnf..

[Pedro Han]

I have tow systems.
fedora 3 and xp sp2
and apm versions are apache 2.0.53, php 4.3.11, mysql 4.1.12

I want to use utf8 and wrote my.cnf as;

[client]
port = 3306
socket = mysql
default-character-set=utf8

[mysqld]
port = 3306
socket = mysql
skip-locking
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
[mysql]
default-character-set=utf8

But,

mysql> show variables like "%character%";show variables like "%collation%";
+--------------------------+------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | \xampp\mysql\share\charsets/ |
+--------------------------+------------------------------+
7 rows in set (0.00 sec)

+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-------------------+

Plaese let me know what should I do for making these UTF8.
latin1 -> uft8
latin1_swedish_ci -> utf8_general_ci

I don't want to use "set names utf8" in php.


What am I missing?




Edited 1 time(s). Last edit at 06/01/2005 03:26AM by Pedro Han.