Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi friend did you find a solution for this? I have the same problem but with character 0xefbfbd using Postgre 9.
Hi We fix the problem with a ODBC Driver Unicode x64 for Postgre.
what is the EtA on this fix? I am having same issue
Is a old issue the only thing i remember is using ODBC Driver Unicode x64 for Postgre.
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!
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.
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!