Re: Encoding SQLite Accents Ordering

[moritz]

in reply to Encoding SQLite Accents Ordering

You're (probably correctly) decoding the incoming data from SQLite. But then you also need to store your script in UTF-8, and use utf8; to tell perl about the encoding of the script itself.

[fanticla]

I am struggling with a similar problem. I tried out what welle posted, my script is encoded in utf8 and "use utf8". It seems as the tr/ is not working properly

[moritz]

In general, tr/// works fine with Unicode strings.

If it doesn't work for you, it means that the data strings aren't in the encoding you think they are, or don't match your expectation in some other way.

So it's time you start debugging; I can recommend Devel::Peek for it. See also: Unicode and encoding in Perl.