Hello.
Please check, if putting of these lines into my.cnf solves the problem: [dbdmysql] default-character-set = ujis I've found this suggestion at: http://lists.mysql.com/perl/2286 Batara Kesuma <[EMAIL PROTECTED]> wrote: > 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 > > > -- 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]