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

From Cristian Prieto
Subject Re: COPY and Unicode...
Date
Msg-id 20050921210702.8C8B110558@mail.clickdiario.com
Whole thread Raw
In response to Re: COPY and Unicode...  (Douglas McNaught <doug@mcnaught.org>)
List pgsql-general
Thanks a lot! Your help was very handy!

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Douglas McNaught
Sent: Miércoles, 21 de Septiembre de 2005 02:39 p.m.
To: Cristian Prieto
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] COPY and Unicode...

"Cristian Prieto" <cristian@clickdiario.com> writes:

> 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?

Are you setting the client_encoding variable before doing the COPY?

-Doug

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: [pgsql-advocacy] YAPC::Israel looking for Perl/Database speakers
Next
From: Yonatan Ben-Nes
Date:
Subject: Re: Slow search.. quite clueless