importing 0xe3809c character, aka wave dash - Mailing list pgsql-bugs

From Jorg Heymans
Subject importing 0xe3809c character, aka wave dash
Date
Msg-id 4305E188.3010003@domek.be
Whole thread Raw
Responses Re: importing 0xe3809c character, aka wave dash  (Jorg Heymans <jh@domek.be>)
List 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

pgsql-bugs by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: [GENERAL] BUG #1830: Non-super-user must be able to copy
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: BUG #1831: plperl gives error after reconnect.