| From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: UTF-8 collation on Windows? |
| Date: | 2014-02-19 20:43:01 |
| Message-ID: | CALSLE1PuyOxSY70R_6=1=kD7abogj111K2ZVHXr6=e+AwgfTdg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Feb 20, 2014 at 2:01 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>wrote:
> Just noticed you are not specifying the template database. Try using
> template0:
>
> createdb -U postgres -E utf8 --lc-ctype=american_usa
> --lc-collate=american_usa -T template0 <DBNAME>
Same result i.e. LC_COLLATE and LC_CTYPE gets set as 'English_United
States.1252'
Had specified template option this earlier too.
Btw in case the specified collation is incompatible then "createdb" binary
complains and instructs to use template0 as template, which isn't the case
here.
The codeset parameter is missed here and hence it takes the collation as
the default one which is 'English_United States.1252'.
Regards...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-02-19 20:54:01 | Re: UTF-8 collation on Windows? |
| Previous Message | John R Pierce | 2014-02-19 20:36:58 | Re: Timezone information |