Postgres: invalid byte sequence for encoding "UTF8": 0xb4

Question

I am trying to import a csv file into postgres table. However getting this error:

invalid byte sequence for encoding "UTF8": 0xb4

Command i am using is:

\copy classified_advertisement from '/tmp/jangoads.csv' using delimiters ',' CSV HEADER ENCODING 'UTF8';

Laurenz Albe · Accepted Answer · 2017-01-17 07:37:17Z

1

Your file is not in UTF-8. Find out its actual encoding and specify that.

answered Jan 17, 2017 at 7:37

Laurenz Albe

257k22 gold badges310 silver badges387 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1