Re: collation_connect problem!!

[Pedro Han]

Pedro Han wrote:
> I've wrote my.cnf
>
>
> # 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
>
> port = 3306
> socket = mysql
> skip-locking
> default-character-set=utf8
> character-set-server = utf8
> collation-server = utf8_general_ci
>
> default-character-set=utf8
>
> 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...


on xp sp2 apache 2.0.54, php 4.3.11, mysql 4.1.12, phpmyadmin 2.6.2pl1

and one more problem,,

at phpmyadmin,

session global
character set client utf8 utf8
character set connection utf8 utf8
character set database utf8 utf8
character set results utf8 utf8
character set server utf8 utf8
character set system utf8 utf8
collation connection utf8_general_ci utf8_general_ci
collation database utf8_general_ci utf8_general_ci
collation server utf8_general_ci utf8_general_ci

It's different from mysql command line.....