Hello.
What version of MySQL do you use? If it's older than 4.0.2, then use set-variable = var_name=value. See: http://dev.mysql.com/doc/mysql/en/Option_files.html Hariett Jones <[EMAIL PROTECTED]> wrote: > 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 > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
