Problems with LATIN2

From: Grzegorz Mucha <mucher(at)tigana(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems with LATIN2
Date: 2001-03-21 11:30:04
Message-ID: 01032112300400.31661@theta
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tigana(dot)pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------
An optimist is a man who looks forward to marriage.
A pessimist is a married optimist

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2001-03-21 14:04:12 Re: Call for platforms
Previous Message Tom Lane 2001-03-21 11:13:46 Re: Call for platforms