Re: Problems importing Unicode - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Problems importing Unicode
Date
Msg-id 20041117.102521.03113524.t-ishii@sra.co.jp
Whole thread Raw
In response to Problems importing Unicode  (matthias@cmklein.de)
List 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

pgsql-general by date:

Previous
From: matthias@cmklein.de
Date:
Subject: How to suppress echo while executing batch files?
Next
From: Michael Fuhr
Date:
Subject: Re: How to suppress echo while executing batch files?