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.
Subject
Views
Written By
Posted
How to set charater_set_server, charater_set_database?
3386
September 02, 2005 01:33AM
2402
September 02, 2005 02:25AM
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.