COPY and Unicode... - Mailing list pgsql-general

From Cristian Prieto
Subject COPY and Unicode...
Date
Msg-id 20050921195703.1F20B10141@mail.clickdiario.com
Whole thread Raw
Responses Re: COPY and Unicode...
Re: COPY and Unicode...
List pgsql-general
Hello, I need to import some amount of data using the COPY command, the main
trouble I found is that the Database is in UNICODE format and the data in
ASCII Latin-1 codepage, when I try to import it, COPY respond with:

ERROR:  invalid byte sequence for encoding "UNICODE": 0xe9
CONTEXT:  COPY geoip_location, line 307, column city: "Yaound"

I've been looking into the documentation and I could not found any reference
in copy from a distinct codepage than the used by the database, any help?

Thanks a lot!


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgres locks table schema?
Next
From: CSN
Date:
Subject: index row size exceeds btree maximum