Problems with LATIN2 - Mailing list pgsql-general

From Grzegorz Mucha
Subject Problems with LATIN2
Date
Msg-id 01032112300400.31661@theta
Whole thread Raw
List pgsql-general
I have encountered some problems while trying to create a database that
would use the Polish locale.
After compiling with --enable-multibyte --enable-locale
--enable-unicode-conversion, I initdb-ed postgres with -E UNICODE and
started the database (the correct locale was set - pl_PL).

However, upon connecting to psql, using \encoding LATIN2 (as suggested by
the iso8859-2 locale) and doing a test :
SELECT upper('acelnoszx'); (these are Polish national chars, not the ASCII
ones), I keep getting the message:

utf_to_latin: could not convert UTF-8 (0xc3a3) ignored
(repeated 3x for different chars).

The letters are not converted to uppercase, either.

When using LATIN2 at initdb it works fine (Unfortunately I need an UTF-8
database for the i18n issues with Tcl8.x), so Unicode support is a must.

Any hints?
--
Grzegorz Mucha <mucher@tigana.pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------
An optimist is a man who looks forward to marriage.
A pessimist is a married optimist

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: error messages VERY misleading...!
Next
From: John Madden
Date:
Subject: Re: Really Dumb Question...(Dumping db)