Re: Unicode support problem

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: js(at)coalitiondev(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unicode support problem
Date: 2005-02-25 01:09:22
Message-ID: 20050225.100922.68032840.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> If I setup the database as follows:
> LANG=C
> initdb -E iso8859_1
> createdb -E iso8859_1
>
> Then it appears to work OK - but I then get an error with character 0xE2
> (Latin small letter a with circumflex):
> ERROR: could not convert UTF-8 character 0x00e2 to ISO8859-1

The error message says all. You are trying to convert an UTF-8
character starting with 0x00e2 to ISO-8859-1, which does not exist in
the world. All ISO-8859-1 chars in UTF-8 are below 0x00e0 range.
Probably you mixed up with ISO-8859-2 or any other characters other
than ISO-8859-1?
--
Tatsuo Ishii

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tzahi Fadida 2005-02-25 01:18:25 Re: Which query is less expensive / faster?
Previous Message Bruce Momjian 2005-02-25 00:53:13 Re: Possible to run the server with ANSI/ISO string escapeing