2010/9/23 Itagaki Takahiro <itagaki.takahiro@gmail.com>:
> On Thu, Sep 23, 2010 at 5:12 PM, Pavel Stehule <pavel.stehule@gmail.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
>