Re: Latin2 and UTF-8 encoding.

From: tomas(at)tuxteam(dot)de
To: "kpeter(at)oszk(dot)hu" <kpeter(at)oszk(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Latin2 and UTF-8 encoding.
Date: 2008-08-25 14:29:38
Message-ID: 20080825142938.GB8619@tomas
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, Aug 25, 2008 at 12:29:14PM +0200, kpeter(at)oszk(dot)hu wrote:
> 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.

You should set the locale to the right value on the server start script.
Make sure your platform supports it.

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

I don't quite understand. You cannot have a database which is UTF-8,
LATIN1 and LATIN2 at the same time.

By the way, this is the wrong list for this question. This list is
dedicated to bugs of PostgreSQL and this is not it.

Feel free to mail pgsql-novice(at)postgresql(dot)org (or mail me privately if
you think I can be of any help).

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIssHSBcgs9XrR2kYRAiHJAJ49drH5Br/Kak2MoRhPUf1HXVuHoQCdFbPO
dRs9T99wV+aKGqsjJDT1bIQ=
=OKLd
-----END PGP SIGNATURE-----

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2008-08-25 14:37:08 Re: [BUGS] BUG #4279: Bad codepage in our web-site
Previous Message Pavel Stehule 2008-08-25 14:28:46 Re: Need default password for the user "sa"