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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
