Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi GandalfGray,
the problem is fixed.
Thanks u,
Limor
Perhaps this is helpful for you:
Postgres OLE DB Driver Recommendations
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/10/odbc-confusion
- Marcus
Thanks, it's an interesting post but the problem still exists
Are you using the PostgreSQL Unicode driver?
/gg
Hi GandalfGray,
the problem is fixed.
Thanks u,
Limor
I was facing the same error but changing from ANSI(X64) to Unicode(x64) in my ODBC conn fixed my issue.
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.