How to set charater_set_server, charater_set_database?
Posted by: Jason Lam
Date: September 02, 2005 01:33AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to set charater_set_server, charater_set_database?
3386
September 02, 2005 01:33AM


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.