CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

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


New User

Aug 15, 2011, 1:29 AM

Post #1 of 1 (8947 views)
Globalisation, UTF8 and characters with Accent. Can't Post


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.


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives