Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group