From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Per-column collation, work in progress |
Date: | 2010-09-23 08:48:05 |
Message-ID: | AANLkTi=LVy8_JxZG+PJ39yASQWHCF=z0E3qCndDco3pq@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2010/9/23 Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>:
> On Thu, Sep 23, 2010 at 5:12 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>> 3. postgres=# select to_char(current_date,'tmday') collate "cs_CZ.utf8";
>> to_char
>> ──────────
>> thursday -- bad result
>> (1 row)
>
> COLLATE means "collation" rather than "locale", no?
ok.
>
>> 5.
>> postgres=# create table xy(a text, b text collate "cs_CZ");
>> ERROR: collation "cs_CZ" for current database encoding "UTF8" does not exist
>> can be there some more friendly message or hint ?
>
> I hope Postgres automatically detects the omitted encoding
> because it knows the database encoding is UTF8.
I know what this issue means, but it needs some detail or hint I think
Regards
Pavel
>
> --
> Itagaki Takahiro
>
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2010-09-23 09:02:50 | Re: Configuring synchronous replication |
Previous Message | Csaba Nagy | 2010-09-23 08:34:54 | Re: Configuring synchronous replication |