COPY and Unicode...

From: "Cristian Prieto" <cristian(at)clickdiario(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: COPY and Unicode...
Date: 2005-09-21 19:51:21
Message-ID: 20050921195703.1F20B10141@mail.clickdiario.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-09-21 19:53:45 Re: Postgres locks table schema?
Previous Message David Fetter 2005-09-21 19:47:26 Re: Fetching column names for a table