UTF8 problem in postgres db

[#1]

Hello All,

I have a date poblem with postgres data, i have a table with strings, that includes strage letters such as: �

I get the following error:

SQL##f - SqlState: 22P05, ErrorCode: 7, ErrorMsg: ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252";

Error while executing the query

I tried to chage the odbc connection to unicode/anse but it is not working.

I'll appreciate any help.

Cheers,

Limor

[marcus_sommer]

Perhaps this is helpful for you:

Postgres OLE DB Driver Recommendations

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/10/odbc-confusion

- Marcus

[#3]

Thanks, it's an interesting post but the problem still exists

[gandalfgray]

Are you using the PostgreSQL Unicode driver?

/gg

[#5 · Accepted solution]

Hi GandalfGray,

Thank, Yes i did use Unicode however I found out that when i change the

SSL_Mode field to Alow instead of disable inside the ODBC connections,

the problem is fixed.

Thanks u,

Limor

[Kallou]

I was facing the same error but changing from ANSI(X64) to Unicode(x64) in my ODBC conn fixed my issue.

[clark_vera]

I was getting the same errors from Power Bi trying to read a Postgres database. The solution was to setup a SYSTEM DSN, (not user DSN) with Postgres SQL35W set to Unicode(x64).

A user DSN of Unicode(x64) did not work.