Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

UTF8 problem in postgres db

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

6 Replies
Not applicable
Author

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

gandalfgray
Specialist II
Specialist II

Are you using the PostgreSQL Unicode driver?

odbsunicode.JPG.jpg

/gg

Not applicable
Author

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
Contributor
Contributor

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

clark_vera
Contributor
Contributor

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.

clark_vera_1-1713195476459.png