Re: ErrorCode 7 when connecting to data source - Qlik Community

Report Inappropriate Content · ‎2011-08-11

Hi, wondering if someone can help we decode the following error when I connect to a PostgressSQL30 datawarehouse... and ideally let me know if there is a solution (I am using ODBC)

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

Error while executing the query

SQL SELECT *

FROM datawarehouse."public".sale

Emmanuelle__Bustos · ‎2013-01-08

Hi friend did you find a solution for this? I have the same problem but with character 0xefbfbd using Postgre 9.

Emmanuelle__Bustos · ‎2013-01-08

Hi We fix the problem with a ODBC Driver Unicode x64 for Postgre.

Report Inappropriate Content · ‎2014-01-13

what is the EtA on this fix? I am having same issue

Emmanuelle__Bustos · ‎2014-01-13

Is a old issue the only thing i remember is using ODBC Driver Unicode x64 for Postgre.

Report Inappropriate Content · ‎2014-01-13

my issue appears to be bad data in one of the fields in the postgres table. I commented out that field and it worked. Hard part is finding the field causing it. One by one commenting out, reloading. Found it finally.

Debbie Pyykkonen

Archipelago IS, LLC | Director, Business Analytics| www.archipelagois.com

303 S. Broadway, Suite 200-169 | Denver, Colorado 80209

Twitter | LinkedIn | Facebook |

(: 303-304-6425 | *: dpyykkonen@archipelagois.com

Check out our Workshops and Events!

Download QlikView for FREE!

Emmanuelle__Bustos · ‎2014-01-13

If you look the original issue is related with one specific field as well, i think we had it the same so try using ODBC Driver Unicode x64 for Postgre. It's only thing i know that can help you because this x64 driver does supports the character error.

Report Inappropriate Content · ‎2014-01-13

thank you. I will give that a try.