We help IT Professionals succeed at work.

0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252"

I'm getting the error below on this statement.  I'm trying to open a connection to a PostgreSQL database.  I have a ODBC data source defined, and I have installed the PostgreSQL ODBC driver.

Dim Reader As OdbcDataReader = catCMD.ExecuteReader()

ERROR [22P05] ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252";
Error while executing the query


Alternatively, can I use an SQL connection object.  If so, what would I specify for Data Source?
Comment
Watch Question

Top Expert 2015

Commented:
i see three bytes in that character.... it is not even UTF8...
I change the driver from ANSI to UNICODE and the problem is resolved.