Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Issue on Varchar Ordering
Date
Msg-id 22930.1143652450@sss.pgh.pa.us
Whole thread Raw
In response to Re: Issue on Varchar Ordering  ("Rodrigo Hjort" <rodrigo.hjort@gmail.com>)
Responses Re: Issue on Varchar Ordering  ("Rodrigo Hjort" <rodrigo.hjort@gmail.com>)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: "Rodrigo Hjort"
Date:
Subject: Re: Issue on Varchar Ordering
Next
From: Heikki Linnakangas
Date:
Subject: Index vacuum improvements