| From: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(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:29:45 |
| Message-ID: | AANLkTi=zza7phKqTRruB-Ju0z0_1oA=uVH3hq+hq+s2W@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
> 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.
--
Itagaki Takahiro
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2010-09-23 08:34:54 | Re: Configuring synchronous replication |
| Previous Message | Pavel Stehule | 2010-09-23 08:12:32 | Re: Per-column collation, work in progress |