topic Re: Error in Qlikview in QlikView

Error in Qlikview

gautik92 — Wed, 25 Nov 2020 16:16:04 GMT

When i am reloading the table am getting this issue

do anyone know how to resolve this issue

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

Error while executing the query

Re: Error in Qlikview

ramasaisaksoft — Thu, 16 Jun 2016 11:16:53 GMT

Hi Gowtham,

Please check your ODBC connection first is it works fine or not?

i mean just write ODBC connection command and reload the app if it success then no issue else ODBC issue

If your connection is success and the table is not coming into Qlikview check for the another table.

else please copy paste your code which you wrote in Script.then we will find easily.

If it is confidential please share to me in personal mail i will give solution ramasaiqvw@gmail.com (call me 8376964364.)

Re: Error in Qlikview

gautik92 — Thu, 16 Jun 2016 11:19:15 GMT

Thanks for the Reply ramasaisaksoft

It is working fine now i changed the configuration in ODBC driver changed ANSI to Unicode

Re: Error in Qlikview

marcus_sommer — Thu, 16 Jun 2016 11:21:49 GMT

There is a conflict between different charsets. Maybe you could customize this within the sql-driver or you tried it with a different one. Further possible might be to convert these value or to exclude them. I hope this led you in the right direction: QLikView, ODBC and UTF-8.

- Marcus

Re: Error in Qlikview

narendiran — Thu, 16 Jun 2016 11:22:46 GMT

Hi Gowtham,

Refer the below blog

The Great ODBC Confusion

Re: Error in Qlikview

ramasaisaksoft — Thu, 16 Jun 2016 12:54:52 GMT

Gowtham,

You already got the solution so,

close this thread by (marked as Help full)

Else this thread is continuing..Do it ASAP