|
|
|
| No such thing as a small change | |
| PerlMonks |
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:
Hi monkers, 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 ... Thx Ayla
Back to
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||||||||