Error in Qlikview

[gautik92]

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

[ramasaisaksoft]

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.)

[gautik92]

Thanks for the Reply ramasaisaksoft

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

[marcus_sommer]

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

[narendiran]

Hi Gowtham,

Refer the below blog

The Great ODBC Confusion

[ramasaisaksoft]

Gowtham,

You already got the solution so,

close this thread by (marked as Help full)

Else this thread is continuing..Do it ASAP