BUG #4616: Create Database with another encoding as the encoding from postgres

Lists: pgsql-bugs
From: "Said Noucair" <noucair(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4616: Create Database with another encoding as the encoding from postgres
Date: 2009-01-15 13:36:04
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4616
Logged by: Said Noucair
Email address: noucair(at)gmail(dot)com
PostgreSQL version: 8.3
Operating system: Suse 2.6
Description: Create Database with another encoding as the encoding
from postgres
Details:

Hi,

I tried to create a second database other than postgres with different
encoding "WIN", but it keep gave me errors:
Error: encoding WIN does not match server's locale UTF-8
> DETAIL: The server's LC_CTYPE setting requires encoding...

Any hint?

Regards


From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4616: Create Database with another encoding as the encoding from postgres
Date: 2009-01-15 14:00:47
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-bugs

Said Noucair написа:
> The following bug has been logged online:
>
> Bug reference: 4616
> Logged by: Said Noucair
> Email address: noucair(at)gmail(dot)com
> PostgreSQL version: 8.3
> Operating system: Suse 2.6
> Description: Create Database with another encoding as the encoding
> from postgres
> Details:
>
> Hi,
>
> I tried to create a second database other than postgres with different
> encoding "WIN", but it keep gave me errors:
> Error: encoding WIN does not match server's locale UTF-8
>> DETAIL: The server's LC_CTYPE setting requires encoding...
>
> Any hint?

Known restriction: "Any character set encoding specified for the new
database must be compatible with the server's LC_CTYPE locale setting."
(http://www.postgresql.org/docs/current/static/sql-createdatabase.html)

--
Milen A. Radev