How to set mysql client charset when complie/install DBD::mysql?

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

Comment on How to set mysql client charset when complie/install DBD::mysql?

Replies are listed 'Best First'.
Re: How to set mysql client charset when complie/install DBD::mysql? by Gilimanjaro (Hermit) on Mar 19, 2010 at 12:09 UTC
Define utf-8 garbage character... Are you sure the data in your table is correct? Are you sure the field/table/database character set is correct? Are you sure your LANG environment variable is correct? Are you sure your terminal character set is set correctly? What garbage are you getting exacty?	[reply]
Re^2: How to set mysql client charset when complie/install DBD::mysql? by pysome (Scribe) on Mar 22, 2010 at 02:17 UTC
thank your attention. 1 The data in my table is corrent. 2 field/table/database character set is correct 3 Lang=UTF8 4 terminal character is also correct. The garbage is such as "???".	[reply]