Could it be that you have put your variables into the wrong section of your configuration file? I haven't been able to look it up to verify my information but I thought the section that starts with [mysql] contained settings for the command line client while the section that starts with [mysqld] contains settings for the server.
I would love to have the link(s) into the manual for the page(s) that describes which section header to use in the INI/CFG file for which product (mysql, mysqld, mysqldump, etc). I know I read it somewhere (a long time ago) but I can't find it today. Thanks! Shawn Green Database Administrator Unimin Corporation - Spruce Pine Hariett Jones <[EMAIL PROTECTED]> wrote on 11/15/2004 06:42:31 AM: > 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] >