Re: LC_COLLATE UTF-8 Locales on Windows?

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.