PostGIS import csv encoding problem

Question

I want to import csv into PostGIS database,

I receive error massage:

alpha=# COPY project FROM '/home/alpha/database/project.csv' DELIMITERS ',' CSV;
ERROR:  invalid byte sequence for encoding "UTF8": 0xc1da
CONTEXT:  COPY project, line 1

so I find my csv's coding is ISO-8859-1 and set encoding = ISO_8859_1

#SET client_encoding = ISO_8859_1;

COPY worked

but I use

SELECT * FROM project

it's give me a lot of garbled words!

so how to make it right??

Answer 1

In my script, I begin with the statement: SET client_encoding = LATIN1; Then COPY table FROM 'D:\folder\file.csv' DELIMITERS ';' CSV HEADER;

Hope this can help