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

From Peter Eisentraut
Subject Re: Latin2 and UTF-8 encoding.
Date
Msg-id 200808251723.09636.peter_e@gmx.net
Whole thread Raw
In response to Latin2 and UTF-8 encoding.  ("kpeter@oszk.hu" <kpeter@oszk.hu>)
List pgsql-bugs
On Monday 25 August 2008 13:29:14 kpeter@oszk.hu wrote:
> ERROR:  encoding LATIN2 does not match server's locale en_AU.UTF-8
> DETAIL:  The server's LC_CTYPE setting requires encoding UTF8.

In 8.3, it no longer works to create databases of different or incompatible
encodings.  You need to pick one encoding for all databases and you need to
pick a locale setting to matches that.

If you work for a Hungarian library, you probably don't want a locale setting
en_AU... either.  Instead, you probably want hu_HU.utf8.

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

UTF-8 can store all characters that LATIN1 and LATIN2 can encode.  You just
need to configure your client encoding correctly and the data sent by the
client will automatically be converted to UTF-8 and back.

pgsql-bugs by date:

Previous
From: tomas@tuxteam.de
Date:
Subject: Re: Latin2 and UTF-8 encoding.
Next
From: "Pavel Stehule"
Date:
Subject: Re: Need default password for the user "sa"