Re: Changing charset ang language

[Michał]

Well, I still have problems with correct settings a charset... When I make this command:
show variables like 'char%';
I recive:
+--------------------------+---------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin2 |
| character_set_results | latin1 |
| character_set_server | latin2 |
| character_set_system | utf8 |
| character_sets_dir | E:\usr\MySQL4.1\share\charsets/ |
+--------------------------+---------------------------------+
7 rows in set (0.00 sec)


Why? In my.ini file I set two variables default-character-set=latin2 and default-collation=latin2_bin, so.. why others variables have still value for example 'latin1'?!

If I make this command sho variables like 'coll%', I recive:
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin2_general_ci |
| collation_server | latin2_general_ci |
+----------------------+-------------------+

The default code page in MySQL is utf-8. So, how to change this charset?How to change variables which are set to 'latin1' etc?