CODEWITHSUNDEEP
postgresql
Dev Singh
Dev Singh

Reputation: 1

Postgres character with byte sequence 0xe2 0x80 0x99 in encoding "UTF8" has no equivalent in encoding "LATIN1

Query failed: ERROR: character with byte sequence 0xe2 0x80 0x99 in encoding "UTF8" has no equivalent in encoding "LATIN1" postgres for specific table getting this error on specific table , how can we update character encoding for specific table in postgres?

Upvotes: 0

Views: 732

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246698

You cannot change the database encoding, and you cannot convert this character to LATIN1. Your options are:

  • use a different client encoding

  • use a different character in the database (UPDATE)

Upvotes: 0

Related Questions