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.