Re: 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.

Perl 6 - second systems done right

Comment on Re: Encoding SQLite Accents Ordering Download Code

Replies are listed 'Best First'.
Re^2: Encoding SQLite Accents Ordering by fanticla (Scribe) on Dec 04, 2010 at 16:41 UTC
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	[reply]
Re^3: Encoding SQLite Accents Ordering by moritz (Cardinal) on Dec 04, 2010 at 19:14 UTC
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. Perl 6 - second systems done right	[reply]