Skip site navigation (1) Skip section navigation (2)

Re: importing 0xe3809c character, aka wave dash

From: Jorg Heymans <jh(at)domek(dot)be>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: importing 0xe3809c character, aka wave dash
Date: 2005-08-22 18:36:06
Message-ID: 430A1B16.2030106@domek.be (view raw or flat)
Thread:
Lists: pgsql-bugs
FWIW, I edited the mappings under
src/backend/utils/mb/Unicode, added the character mappings and rebuilt
postgres to make the characters imported correctly.

Learning more about the problem, it seemed that there is no 100%
standard for mapping certain characters and everyone sort of does them
how they see fit.

Regards
Jorg

Jorg Heymans wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 

In response to

pgsql-bugs by date

Next:From: Paul BrambleDate: 2005-08-22 19:52:08
Subject: Help
Previous:From: Tom LaneDate: 2005-08-22 15:26:36
Subject: Re: BUG #1839: insert into table (column) values (nullif('',''));

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group