Ok, I finally found the solution for this. Posting what worked for me, for
posterity. For some reason,
select name collate "Arabic_Saudi Arabia.1256" from forms order by name asc;
doesn't work. But if I do
create collation arabic (locale='Arabic_Saudi Arabia.1256');
and then
select name collate "arabic" from forms order by name asc;
it works and allows me to collate UTF-8 by any locale, as mentioned in the
PostgreSQL documentation.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/LC-COLLATE-UTF-8-Locales-on-Windows-tp5104187p5106571.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.