
kekahere
New User
Aug 15, 2011, 1:29 AM
Post #1 of 1
(8415 views)
|
Globalisation, UTF8 and characters with Accent.
|
Can't Post
|
|
Hi, I am trying to build a DB(using MySQL) which will contain names from all over the world. Most of the names have various accents associated with them. 1) The "Names" field on the Mysql DB has a "utf8_general_ci" collation 2) I am reading names using XML (using XML::Twig -> $twig->safe_parsefile function) and inserting them into the DB using ($dbh->do(Insert...)) I am unable to get all the accents stored in the correct way! The names have "?" or have the Ascii code like "ě" or "ū". How Do I store it correctly? I am unable to figure out if it is a "MySQL" Collation problem or a perl Problem. Any help / advice is much appriciated. Thank you in advance.
|