MySQL Forums
Forum List  »  Newbie

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...

Options: ReplyQuote


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.