|No such thing as a small change|
How to set mysql client charset when complie/install DBD::mysql?by pysome (Scribe)
|on Mar 19, 2010 at 08:22 UTC ( #829568=perlquestion: print w/replies, xml )||Need Help??|
pysome has asked for the wisdom of the Perl Monks concerning the following question:
Now i wanna connect remote mysql server from Linux. I have installed "DBI" sucessully.
And i can connect the server with mysql-self client too .eg
xx@xx~$ mysql -uxx -pxx -h 10.22.22.22 .
However there is some utf-8 garbage character if i don't modify the my.cnf file.
After i change the my.cnf file,everything is OK. But if i connect the server with a little Perl script,the result is still garbage character.
I know i can fix the issues by adding $dbh->do('set charset=xxx') or announce an additional parameter "mysql_read_default_file=/etc/my.cnf" when connect().
I want to know if there is "a better" way to resolve this issues. Such as reinstall DBD::mysql ...
Back to Seekers of Perl Wisdom