Latin2 and UTF-8 encoding. - Mailing list pgsql-bugs

From kpeter@oszk.hu
Subject Latin2 and UTF-8 encoding.
Date
Msg-id 48B2897A.20802@oszk.hu
Whole thread Raw
Responses Re: Latin2 and UTF-8 encoding.
Re: Latin2 and UTF-8 encoding.
Re: Latin2 and UTF-8 encoding.
List pgsql-bugs
Dear Sur!

My name is Peter Kovacs and I work at the National Szechenyi Library in
Hunagry.
The reason why im writing this letter is the follow:
We are using Potgresql to store our data. We have UTF-8, LATIN1 and
LATIN2 encoded databases.
I haven't got any problem with database encoding before, but when I
tried ro restore our database dumps to a postgresql 8.3.3 server it faild.
If I tried to create a database with NON-UTF-8 character encoding I got
the following error:

*SQL error:*

ERROR:  encoding LATIN2 does not match server's locale en_AU.UTF-8
DETAIL:  The server's LC_CTYPE setting requires encoding UTF8.

*In statement:*
CREATE DATABASE "probadb" WITH ENCODING='LATIN2'


The problem is that we need both UTF-8, LATIN1 and LATIN2 characters.

My question is: How could I create a database with NON-UTF-8 encoding.

Regards!

Peter Kovacs

pgsql-bugs by date:

Previous
From: "Janardhanachari, Jagadeesha"
Date:
Subject: Need default password for the user "sa"
Next
From: "Pavel Stehule"
Date:
Subject: Re: Need default password for the user "sa"