importing 0xe3809c character, aka wave dash

From: Jorg Heymans <jh(at)domek(dot)be>
To: pgsql-bugs(at)postgresql(dot)org
Subject: importing 0xe3809c character, aka wave dash
Date: 2005-08-19 13:41:28
Message-ID: 4305E188.3010003@domek.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I am having problems importing sql files containing WAVE DASH or MINUS
character :

WARNING: ignoring unconvertible UTF-8 character 0xe3809c
WARNING: ignoring unconvertible UTF-8 character 0xe28892

The data contains japanese characters and is imported correctly apart
from these two. It seems that postgres is filtering out these characters
during import, resulting in incorrect data.

I have isolated a small (<1kb) testcase for the wavedash,
www.domek.be/testwavedash.sql.

Note that the sql files are produced using postgis' shp2pgsql tool from
ESRI shape files.

The database is setup using EUC_JP encoding.

Regards
Jorg

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-08-19 13:56:39 Re: BUG #1831: plperl gives error after reconnect.
Previous Message Stephen Frost 2005-08-19 13:15:52 Re: BUG #1830: Non-super-user must be able to copy from a