3 Replies Latest reply: Aug 22, 2011 12:03 PM by mdeodhar RSS

    Unable to read Chinese Characters....please help

      Hi

       

      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