Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

3 Replies
Not applicable

Unable to read Chinese Characters....please help

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

Not applicable

Unable to read Chinese Characters....please help

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

Not applicable

Unable to read Chinese Characters....please help

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

Community Browser