2010/9/23 Itagaki Takahiro <itagaki.takah...@gmail.com>: > On Thu, Sep 23, 2010 at 5:12 PM, Pavel Stehule <pavel.steh...@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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
