collation_connect problem!!
Posted by:
Pedro Han
Date: May 29, 2005 08:03PM
I've wrote my.cnf
[client]
# password = your_password
port = 3306
socket = mysql
character_set_connection=utf8;
character_set_results=utf8;
character_set_client=utf8;
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
[mysqld]
port = 3306
socket = mysql
skip-locking
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
[mysqldump]
default-character-set=utf8
[mysql]
default-character-set=utf8
And, db is only
mysql,cdcol,webauth with utf8 in db.opt
but, after
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 |
+----------------------+-------------------+
3 rows in set (0.00 sec)
I want utf8 character set, collation.
What am I missing?
Pleaze help...
Subject
Written By
Posted
collation_connect problem!!
May 29, 2005 08:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.