Aug 15, 2011, 1:29 AM
Post #1 of 1
Globalisation, UTF8 and characters with Accent.
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.