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...