Unable to read Chinese Characters....please help

Wed, 17 Aug 2011 13:37:53 GMT

I am trying to build a QVD file. My source data is a DB2 table located on IBM AS/400 system. Some of the columns in the table contain Chinese characters. I am trying to load the table using ODBC and generate a QVD. Qlikview gives error when the load starts. I have attached the error long file below. If I exclude the columns with Chinese characters from the load statement then it works. I am using Windows 7 and my language settings for Non-Unicode programs is set to "Chinese" but still no good.

Has anybody experienced the same problem ??

Thanks a lot in advance for helping.

Mandar

Qlikview load error

ODBC read failed

JDE_SO_Data:

SQL SELECT *

FROM S102LAPM.JDEINTLIB.F5682QV

SQL SELECT *

8/17/2011 9:36:32 AM: 0017 FROM S102LAPM.JDEINTLIB.F5682QV

8/17/2011 9:36:34 AM: 98 fields found: WFSRP3, W1DL01, WFSRP2, W2DL01, WFSRP1, W3DL01, WFDOCO, WFDCTO, WFKCOO, WFNAME, WFLNID, WFLNTY, WFROUT, WFPRP1, WFDESC, WFVR01, WFMCU, WFTRDJ, WFDRQJ, WFADDJ, WFDGL, WFIVD, WFDGJ, WFDOC, WFDCT, WFORIG, W4DL01, WFLITM, WFAITM, WFDSC1, WFDSC2, WFAC03, WFAN8, WFALPH, WFAC11, W5DL01, WFSHAN, W2ALPH, WFAC13, W6DL01, WFDL01, WFADD1, WFADD2, WFADD3, WFADD4, WFDL02, WFCTY1, WFLOTN, WFLOCN, WFNXTR, W7DL01, WFLTTR, W8DL01, WFUORG, WFSOQS, WFSOBK, WFCRCD, WFTXR1, WFUPRC, WFFEP, WFAEXP, W2AEXP, W3AEXP, W4AEXP, WFUNCS, WFECST, W5AEXP, W6AEXP, WFRATE, WFLPRC, W7AEXP, WFFUP, WFFEA, W8AEXP, WFFUC, WFFEC, W9AEXP, WFSRP7, W2UNCS, WAAEXP, WFSLSM, WFALP1, WFAC02, W9DL01, WFSLM2, W3ALPH, WFPTC, WFDTE, WFANFL, WFCCPR, WFAC14, WADL01, WFOPRD, WFRMK, WFVEND, W2VEND, WFPRP2, WFUPMJ,

SQL Error:[IBM][System i Access ODBC Driver]Error in assignment.

SQL Scriptline:

SQL State:22005

8/17/2011 9:36:38 AM: Error: ODBC read failed

Unable to read Chinese Characters....please help

Fri, 19 Aug 2011 12:42:24 GMT

Hi Mandar,

have you loaded chinese fonts into your Windows System??

If you know chinese is a pictorial language.. it doesn't contain alphabets, so there might be some problems in data load without the chinese fonts.

hope this helps

Rgrds,

Abhinava

Unable to read Chinese Characters....please help

Mon, 22 Aug 2011 16:02:07 GMT

Hi Abhinav

thanks for your reply. Yes, I have already enabled Chinese font in my Windows. It still gives the same error when I try to load the script.

Mandar

Unable to read Chinese Characters....please help

Mon, 22 Aug 2011 16:03:34 GMT

Hi Abhinav

thanks for your reply. Yes, I have already enabled Chinese font in my Windows. It still gives the same error when I try to load the script.

Mandar

topic Unable to read Chinese Characters....please help in QlikView

Unable to read Chinese Characters....please help

Unable to read Chinese Characters....please help

Unable to read Chinese Characters....please help

Unable to read Chinese Characters....please help