Re: How to Right a correct my.cnf? or to set charater_set_server, charater_set_database?

[Jason Lam]

is it a must for me to recompile from source?
or any other method to set the
- character_set_server
- character_set_database
- collation_server
- collation_database
permanently?

if recomplie is needed, may i also have the command i needed for compiling MySQL with charset utf8 on a RedHat 9?

folloing is my current MySQL setting: (+the setting i need)
mysql> SHOW VARIABLES LIKE 'c%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 | (utf8)
| character_set_results | utf8 |
| character_set_server | latin1 | (utf8)
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci | (utf8)
| collation_server | latin1_swedish_ci | (utf8)
| concurrent_insert | ON |
| connect_timeout | 5 |
+--------------------------+----------------------------+



Edited 1 time(s). Last edit at 09/02/2005 02:28AM by Jason Lam.