Character with encoding UTF8 has no equivalent in WIN1252

postgresql encoding utf-8 character
Monis Iqbal picture Monis Iqbal · Oct 14, 2009 · Viewed 75.7k times · Source

I am getting the following exception:

Caused by: org.postgresql.util.PSQLException: ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252"

Is there a way to eradicate such characters, either via SQL or programmatically?
(SQL solution should be preferred).

I was thinking of connecting to the DB using WIN1252, but it will give the same problem.

Answer

airstrike picture airstrike · Oct 15, 2013

I had a similar issue, and I solved by setting the encoding to UTF8 with \encoding UTF8 in the client before attempting an INSERT INTO foo (SELECT * from bar WHERE x=y);. My client was using WIN1252 encoding but the database was in UTF8, hence the error.

More info is available on the PostgreSQL wiki under Character Set Support (devel docs).

Related questions

UTF-8 / Unicode Text Encoding with RPostgreSQL

I'm running R on a Windows machine which is directly linked to a PostgreSQL database. I'm not using RODBC. My database is encoded in UTF-8 as confirmed by the following R command: dbGetQuery(con, "SHOW CLIENT_ENCODING") # client_encoding # 1 UTF8 …

Read More
encoding UTF8 does not match locale en_US; the chosen LC_CTYPE setting requires encoding LATIN1

While trying to install opennms : /usr/share/opennms/bin/install -l /usr/local/lib -dis I get the error: ERROR: encoding UTF8 does not match locale en_US Detail: The chosen LC_CTYPE setting requires encoding LATIN1. and I'm not …

Read More
Postgres issue encoding "UTF8" has no equivalent in encoding "LATIN1"

Our postgres production database server has a database called crd_production which is born out of the template1 template database. Incidentally, on an Ubuntu 12.04 box, the default encoding of the template1 and template0 databases on initial creation of the pgcluster …

Read More