Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Encoding SQLite Accents Orderingby welle (Beadle) |
on Dec 04, 2010 at 11:11 UTC ( [id://875357]=perlquestion: print w/replies, xml ) | Need Help?? |
welle has asked for the wisdom of the Perl Monks concerning the following question: Hello! I'm searching for your wisdom concerning an encoding issue. I'm reading a SQLite database with data encoded in utf-8. I need to the data order alphabetically and print them out. Here is the problem with accented characters. I am using the following code (it worked perfectly with an older SQLite DB without UTF8 data.
As I said before, it worked well order->aäbcoö with my old SQLite DB (no UTF data). Now unfortunatly I populate the DB with UTF-data and when I read out the data from the DB ordering it with the above script, I can't order the data properly. I get something as order->abcoäö Any idea what I am doing wrong? Encoding issues in Perl drive me crasy.... Welle
Back to
Seekers of Perl Wisdom
|
|