Home: Perl Programming Help: DBI:
Globalisation, UTF8 and characters with Accent.

New User

Aug 15, 2011, 1:29 AM

Views: 8955
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.