Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 44926
Status: resolved
Priority: 0/
Queue: DBD-SQLite

Owner: Nobody in particular
Requestors: ambs [...]

Bug Information
Severity: (no value)
Broken in: 1.21
Fixed in: (no value)

Subject: Collation perllocale is doing nothing...
Download (untitled) / with headers
text/plain 570b
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
LC_COLLATE should be used. Not LC_CTYPE. Sorry for the spam. Cheers ambs

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to