Subject: | Collation perllocale is doing nothing... |
Hello
Probably it is my fault, but I am not getting the perllocale collation
working.
I set my current locale with:
use POSIX qw(locale_h);
setlocale(LC_CTYPE, "pt_PT.utf8");
use locale;
Then, I open the database, and set unicode flag to true.
my query uses COLLATION perllocale:
SELECT id, title FROM music ORDER BY title COLLATE perllocale
but I get the list ordered as before. No matter if I change to use or
not the collation, it works always the same.
I am running perl 5.10.
Let me know if I can help debugging with more information.
All the best,
Alberto