Hi, Thank you very much for the reply.
> $dbh->do("SET character_set_results="ujis"'); This works! Is there any way I can set this value on MySQL config file, so I don't need to change all my scripts? Right now my my.cnf looks like: [mysqld] default-character-set=ujis default-collation=ujis_japanese_ci [client] default-character-set=ujis [mysql] default-character-set=ujis > > What do your 'show' statements return when you execute them from the > > perl script? character_set_client ujis character_set_connection latin1 character_set_database ujis character_set_results latin1 character_set_server ujis character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ Why does character_set_connection set back to latin1? I already set the ujis value in my.cnf, and if I connect using mysql client, this value is correctly set to ujis. How can I set character_set_connection so it defaults to ujis, no matter where is the connection coming from? --bk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]