Re: Per-column collation, proof of concept

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: Jaime Casanova <jaime@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2010-08-18T16:29:25Z
Lists: pgsql-hackers
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.