Re: Per-column collation, proof of concept

On Mon, Aug 16, 2010 at 10:56 PM, Peter Eisentraut  wrote:
> On lör, 2010-08-14 at 02:05 -0500, Jaime Casanova wrote:
>
>> BTW, why the double quotes?
>
> Because the name contains upper case letters?
>

why everything seems so obvious once someone else state it? :)

>> sorry to state the obvious but this doesn't work on windows, does it?
>
> Probably not, but hopefully there is some similar API that could be used
> on Windows.
>

good luck with that! ;)
seriously, maybe this helps
http://msdn.microsoft.com/en-us/library/system.windows.forms.inputlanguage.installedinputlanguages.aspx
but probably you will need to write the code yourself... at least i
don't think there is something like "locale -a"

>> and for some reason it also didn't work on a centos 5 (this error
>> ocurred when initdb'ing)
>> """
>> loading system objects' descriptions ... ok
>> 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

(i'm attaching the locales.txt just in case)

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