Postgres Pro
Downloads
Home   >   mailing lists

Thread: Encoding

Encoding

From
Gustavo Rosso
Date:
This error give me to load a file into postgres:
ERROR:  invalid byte sequence for encoding "UTF8": 0xa4

I must force load data.
How must to do?

Re: Encoding

From
Alvaro Herrera
Date:
Gustavo Rosso escribió:
> This error give me to load a file into postgres:
> ERROR:  invalid byte sequence for encoding "UTF8": 0xa4
>
> I must force load data.
> How must to do?

Set client_encoding to latin1 (or latin9).  How you do this is
client-dependent.

Note that you can post questions in spanish in pgsql-es-ayuda.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.