CODEWITHSUNDEEP
postgresqlcharacter-encoding
Amit Gupta
Amit Gupta

Reputation: 21

Character with byte sequence 0xe2 0x80 0xa6 in encoding utf8 has no equivalent in encoding latin1

I am importing a CSV file into a PostgreSQL table through the PostgreSQL import functionality, but I get this error:

character with byte sequence 0xe2 0x80 0xa6 in encoding utf8 has no equivalent in encoding latin1

Please help me out with this...

Upvotes: 0

Views: 6022

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246268

You are trying to import an UTF-8 file that contains the character … (“horizontal ellipsis”, Unicode code point 2026).

This character cannot be encoded in LATIN1, so you will not be able to do that.

Either use a database with encoding UTF8 or edit the import file to remove the character.

Upvotes: 3

Related Questions