In your ini/cnf play around with the "default-character-set" variables.
[mysql] # default-character-set=latin1 default-character-set=utf C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51b-community-nt MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like 'character_set_connection'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | character_set_connection | utf8 | +--------------------------+-------+ 1 row in set (0.00 sec) mysql> exit Bye //changed the ini... C:\Program Files\MySQL\MySQL Server 5.0\bin>net stop mysql The MySQL service is stopping. The MySQL service was stopped successfully. C:\Program Files\MySQL\MySQL Server 5.0\bin>net start mysql The MySQL service is starting. The MySQL service was started successfully. C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51b-community-nt MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like 'character_set_connection'; +--------------------------+--------+ | Variable_name | Value | +--------------------------+--------+ | character_set_connection | latin1 | +--------------------------+--------+ 1 row in set (0.00 sec) On Sun, Sep 28, 2008 at 9:11 AM, Luigi Perroti <[EMAIL PROTECTED]> wrote: > Hi, I'm currently using the official MySQL binaries and I have to > issue 'SET NAMES utf8' queries on every connection to override the > default values for character_set_connection and collation_connection. > > I was wondering how to avoid the overhead that issuing these queries > introduces. After some searching it appears that my only option would > be to recompile the server with the desired defaults. > Is this correct or is there another way to achieve the same effect? > > Thanks for your time! > > Regards, > Luigi > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]