Re: Latin2 and Unicode problems

From: Grzegorz Mucha <mucher(at)tigana(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Latin2 and Unicode problems
Date: 2001-04-20 05:37:42
Message-ID: 01042007374200.00707@theta
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well, I didn't state it correctly, then. When I use iso8859-2, Postgres is
compiled with --enable-locale only (though compiling it with UNICODE
support, then creating database with ISO encoding works fine - sorting,
upper/lower case conversion).

However, when creating db with Unicode, no matter if I try to use
ISO8859-2 or Unicode client encoding, the db doesn't get it right - such
functions as upper/lower etc. give unpredictable results (as the result
of select upper('some-polish-chars') return even some three-byte unicode
chars). I quite frequently get the following message:

utf_to_latin: could not convert UTF-8 (0xc3a3) ignored
(the Unicode char code varies...)

--
Grzegorz Mucha <mucher(at)tigana(dot)pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------
Quidquid id est, timeo Danaos et dona ferentes.
Wergiliusz, "Eneida"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hitesh Patel 2001-04-20 06:08:20 PL/Perl Question
Previous Message Diana Cionoiu 2001-04-20 02:48:29 Re: client ssl