From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Dev Kumkar <devdas(dot)kumkar(at)gmail(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:54:01 |
Message-ID: | 530519E9.6010202@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/19/2014 12:43 PM, Dev Kumkar wrote:
> On Thu, Feb 20, 2014 at 2:01 AM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto: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'.
Alright last shot:)
Taking hint from here:
http://msdn.microsoft.com/en-us/library/x99tb11d.aspx
try:
createdb -U postgres -E utf8 -l en-US <DBNAME>
If that does not work, not sure where to go.
>
> Regards...
From | Date | Subject | |
---|---|---|---|
Next Message | Dev Kumkar | 2014-02-19 20:54:53 | Re: Timezone information |
Previous Message | Dev Kumkar | 2014-02-19 20:43:01 | Re: UTF-8 collation on Windows? |