Character encoding problems and dump import

From: <ogjunk-pgjedan(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Character encoding problems and dump import
Date: 2006-03-20 20:21:35
Message-ID: 20060320202135.86240.qmail@web50302.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have a dump (non-binary, if it matters) of a DB that has some characters in it that my DB doesn't want to take.
I'm using PG 8.0.3 and it was created with Unicode support:

=> \encoding
UNICODE

Characters that cause problems during the import are things like:
é and other characters from the Extended ASCII table (c.f. bottom of http://www.lookuptables.com/ )
Also:
'ÇѱÛÀÌ Á¦´ë·Î µÇ´ÂÁö ½ÇÇè... ¿©±â¿¡´Â ¾Æ¹« ¸µÅ©µµ ¾ø½À´Ï´Ù.±×³É ÀÌ ³»¿ë¹Û¿¡ ¾ø½À´Ï´Ù.'

The errors I get on import are of this type:
ERROR: invalid byte sequence for encoding "UNICODE": 0xdb20

The data may not be the cleanest, and I have limited control over that.
But I am wondering if there is any way I can import this data, even if that means converting some of the characters into something else.

Thanks,
Otis

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mr. Dan 2006-03-20 21:19:30 hiding the postgres password - v8.1.0
Previous Message Luis P. Mendes 2006-03-20 19:39:10 Re: use of <END> in psql