Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

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

by pysome (Scribe)
on Mar 19, 2010 at 08:22 UTC ( [id://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

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?
      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 "???".

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://829568]
Approved by Corion
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2024-03-28 13:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found