How to set charater_set_server, charater_set_database?

[Jason Lam]

i am try to set the default charater set, but encounter the following problems,

these 2 lines work correctly, but only affect charater_set_client & charater_set_connection:

default-character-set=utf8
character-sets-dir=/usr/share/mysql/charsets

-------------------------------------------------------------------
any single line of the following cause errors, unknow variable ......
-------------------------------------------------------------------

set-variable=key_buffer_size=16M # i copy this line from MySQL mannal for testing

init_connect="SET NAMES utf8"# i copy this line from one of the thread in this forum

default-collation=utf8_general_ci

character_set=utf8

character_set_client=utf8

character_set_server=utf8

collation_database=utf8_general_ci

eg.
unknow variable 'default-collation=utf8_general_ci'
-------------------------------------------------------------------
is there any method to set the charater_set_server and charater_set_database instead of calling
mysql_query("SET NAMES utf8", $link);
everytime?

If anyone can help that'd be much appreciated

Jason



Edited 4 time(s). Last edit at 09/03/2005 05:44AM by Jason Lam.