Re: MSSQL to PostgreSQL : Encoding problem

Arnaud Lesauvage wrote:

> mydb=# SET client_encoding TO LATIN9;
> SET
> mydb=# COPY statistiques.detailrecherche (log_gid,
> champrecherche, valeurrecherche) FROM
> 'E:\\Production\\Temp\\detailrecherche_ansi.csv' CSV;
> ERROR: invalid byte sequence for encoding "LATIN9": 0x00
> HINT: This error can also happen if the byte sequence does
> not match the encoding expected by the server, which is
> controlled by "client_encoding".

Huh, why do you have a "0x00" byte in there? That's certainly not
Latin9 (nor UTF8 as far as I know).

Is the file actually Latin-something or did you convert it to something
else at some point?

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