Re: [GENERAL] COPY and Unicode...

2005-09-21 Thread Cristian Prieto
Thanks a lot! Your help was very handy! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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

Re: [GENERAL] COPY and Unicode...

2005-09-21 Thread Tom Lane
"Cristian Prieto" <[EMAIL PROTECTED]> 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 sequ

Re: [GENERAL] COPY and Unicode...

2005-09-21 Thread Douglas McNaught
"Cristian Prieto" <[EMAIL PROTECTED]> 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 se

[GENERAL] COPY and Unicode...

2005-09-21 Thread Cristian Prieto
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