Re: UTF-8 collation on Windows?

On 02/19/2014 12:43 PM, Dev Kumkar wrote:
> On Thu, Feb 20, 2014 at 2:01 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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...