Hi, I have a problem with character_set_results on MySQL 4.1. I have this in my my.cnf:
[mysqld] default-character-set=ujis default-collation=ujis_japanese_ci [client] default-character-set=ujis [mysql] default-character-set=ujis If I connect from mysql client, and do 'show variables' I get the right (ujis) character_set_results. But, when I connect from Perl DBI, I get latin1 instead of ujis. The only way to force the character_set_results to ujis in Perl DBI is to do: $dbh->do("SET character_set_results="ujis"'); Is there any way to set the character_set_results in my.cnf, so I don't need to do it from Perl DBI every time I connect? Regards, --bk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]