Re: Per-column collation, proof of concept - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Per-column collation, proof of concept
Date
Msg-id AANLkTi=cAmemjG16qPYXtyuOi9UDe222+LFrL7wTv7pp@mail.gmail.com
Whole thread Raw
In response to Re: Per-column collation, proof of concept  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Wed, Aug 18, 2010 at 11:29 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
> On tis, 2010-08-17 at 01:16 -0500, Jaime Casanova wrote:
>> >> creating collations ...FATAL:  invalid byte sequence for encoding
>> >> "UTF8": 0xe56c09
>> >> CONTEXT:  COPY tmp_pg_collation, line 86
>> >> STATEMENT:  COPY tmp_pg_collation FROM
>> >> E'/usr/local/pgsql/9.1/share/locales.txt';
>> >> """
>> >
>> > Hmm, what is in that file on that line?
>> >
>> >
>>
>> bokmål  ISO-8859-1
>
> Hey, that borders on genius: Use a non-ASCII letter in the name of a
> locale whose purpose it is to configure how non-ASCII letters are
> interpreted. :-/
>
> Interestingly, I don't see this on a Debian system.  Good thing to know
> that this needs separate testing on different Linux variants.
>
>

Yeah! and when installing centos 5 i don't have a chance to choose
what locales i want, it just installs all of them

--
Jaime Casanova         www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: git: uh-oh
Next
From: Josh Berkus
Date:
Subject: Re: Return of the Solaris vacuum polling problem -- anyone remember this?