Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ErrorCode 7 when connecting to data source

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

7 Replies
Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

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

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author

thank you. I will give that a try.

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!