I want to set some variables once and for all. How should i do it ?
I need following vars to be set :
character_set_client=latin2 character_set_connection=latin2 character_set_database=latin2 character_set_results=latin2 character_set_server=latin2 character_set_system=latin2 collation_connection=latin2_bin collation_database=latin2_bin collation_server=latin2_bin
i have put them into /etc/my.cnf ,but it does not work.
[mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates character_set_client=latin2 character_set_connection=latin2 character_set_database=latin2 character_set_results=latin2 character_set_server=latin2 character_set_system=latin2 collation_connection=latin2_bin collation_database=latin2_bin collation_server=latin2_bin
The variables appear to be : variable session value global value
character set client latin1 latin2
character set connection latin1 latin2
character set database latin2 latin2
character set results latin1 latin2
character set server latin2 latin2
character set system utf8 utf8
character sets dir /usr/local/mysql/share/mysql/charsets/ /usr/local/mysql/share/mysql/charsets/
collation connection latin1_swedish_ci latin2_general_ci
collation database latin2_general_ci latin2_general_ci
collation server latin2_general_ci latin2_general_ci
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]