Re: Issue on Varchar Ordering - Mailing list pgsql-hackers

From Rodrigo Hjort
Subject Re: Issue on Varchar Ordering
Date
Msg-id 731083980603291210u52672821udcf2977cbfe9d137@mail.gmail.com
Whole thread Raw
In response to Re: Issue on Varchar Ordering  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Thanks all. I'm gonna try other locales and encodings.


2006/3/29, Tom Lane <tgl@sss.pgh.pa.us>:
"Rodrigo Hjort" <rodrigo.hjort@gmail.com> writes:
> The fact is that I can't raise PostgreSQL with C encoding, as special
> characters are used on most tables.

You're confusing locale and encoding, which are two different (though
interrelated) things.

I suspect the right choice for you will be to use C locale with UTF8
encoding, or possibly one of the LATINn encodings.

                        regards, tom lane


--
Regards,

Rodrigo Hjort
GTI - Projeto PostgreSQL
CELEPAR - Cia de Informática do Paraná
http://www.pr.gov.br

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Index vacuum improvements
Next
From: David Fetter
Date:
Subject: Win32 sysconfig -> pg_service.conf