cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ayupchap Member
Member

ODBC Error - Not sure how to resolve it

Hi all

 

OK so I am getting this error with an SQL query:

 

Details: "ODBC: ERROR [22P05] ERROR: character with byte sequence 0xe2 0x80 0x8e in encoding "UTF8" has no equivalent in encoding "WIN1252";
Error while executing the query"

 

 

Anyone know how I can get around this issue?

4 REPLIES 4
HotChilli Established Member
Established Member

Re: ODBC Error - Not sure how to resolve it

Postgres?

 

If so, you'll need to change character encoding to unicode (maybe in the DSN)-  (or find a different driver as in this    ssrs odbsc error thread )

Ayupchap Member
Member

Re: ODBC Error - Not sure how to resolve it

Ah ok, yes, postgres

 

So I changed the DSN to unicode in the ODBC connector.  I thought it had worked as it shows me the load sample data

 

odbc error.PNGerror 2 odbc.PNG

Any idea why this might still be happening?  Thanks for your help on this.  

HotChilli Established Member
Established Member

Re: ODBC Error - Not sure how to resolve it

Getting closer!

Can you experiment by clicking 'edit'  instead of load.  Can you get to the Advanced editor and try a different encoding?  Try selecting a more limited selection of fields.  That might help you discover whether it's an unusual character that doesn't translate to code page 1252 in Windows or a hidden character.

 

 

Found this on the forum:

Using the postgres ODBC and configuring the connection in unicode mode on System DSN the issue is solved (PBI connection will be ODBC)

https://www.postgresql.org/ftp/odbc/versions/dll/

 

dataco Frequent Visitor
Frequent Visitor

Re: ODBC Error - Not sure how to resolve it

Hi,

 

I have same problem, anyone have find out solution?, please