Re: Problems importing Unicode

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: matthias(at)cmklein(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems importing Unicode
Date: 2004-11-17 01:25:21
Message-ID: 20041117.102521.03113524.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I have batch files with entries such as
>
> INSERT INTO country VALUES (248,'ALA','AX','Åland Islands');
> INSERT INTO country VALUES (384,'CIV','CI','Côte d\'Ivoire');
>
> I tried to execute them using "pgsql \i filename.sql"
>
> Unfortunately, I keep getting an error message:
> "ERROR: invalid byte sequence for encoding "UNICODE": 0xc56c"
>
> How can that be possible?
> My database is set to encoding "UNICODE" and so are the batchfiles.
>
> Why does that not work?

I bet your batch file is not encoded in UNICODE (UTF-8).
--
Tatsuo Ishii

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-11-17 01:27:46 Re: How to suppress echo while executing batch files?
Previous Message matthias 2004-11-17 01:17:16 How to suppress echo while executing batch files?