topic Re: UTF8 problem in postgres db in QlikView

UTF8 problem in postgres db

Thu, 06 Mar 2014 08:40:38 GMT

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

Re: UTF8 problem in postgres db

marcus_sommer — Thu, 06 Mar 2014 15:02:18 GMT

Perhaps this is helpful for you:

Postgres OLE DB Driver Recommendations

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

- Marcus

Re: UTF8 problem in postgres db

Tue, 11 Mar 2014 13:56:38 GMT

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

Re: UTF8 problem in postgres db

gandalfgray — Tue, 11 Mar 2014 14:02:43 GMT

Are you using the PostgreSQL Unicode driver?

/gg

Re: UTF8 problem in postgres db

Wed, 12 Mar 2014 08:55:58 GMT

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

Re: UTF8 problem in postgres db

Kallou — Fri, 10 Jun 2022 09:32:04 GMT

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

Re: UTF8 problem in postgres db

clark_vera — Mon, 15 Apr 2024 15:38:20 GMT

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.