Skip site navigation (1) Skip section navigation (2)

Re: LC_COLLATE UTF-8 Locales on Windows?

From: wdrose <wrose(at)terraframe(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: LC_COLLATE UTF-8 Locales on Windows?
Date: 2011-12-29 01:57:22
Message-ID: 1325123842303-5106571.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

In response to

Responses

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2011-12-29 12:15:27
Subject: Re: LC_COLLATE UTF-8 Locales on Windows?
Previous:From: William RoseDate: 2011-12-27 21:53:16
Subject: LC_COLLATE UTF-8 Locales on Windows?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group