Displaying Unicode UTF-8 characters in QlikView

[#1]

I have a client who stores his data in Simplified Chinese, but it is in Unicode UTF-8 format. If it is in ASCII I can display it fine in QlikView, but unfortunately for operational reasons they must use the Unicode set. Does anyone know if there is a way to display this correctly?

Thanks in advance

Trevor Doble

[#2]

Hi Jeffrey,

There is something new I learned. Turns out Qlikview is not complaining for Chinese characters. It is something else...

So basically in my test I created a QV script to load only one field from the source table. This field contains Chinese characters. When I run the script it loaded all the rows in the table and displays Chinese as well. When I modify the script to load all the fields from the source table and then try to load. This time it loaded only 1800 rows. Also gave the error. So the error is something to do with the size of data. Here is the log file....

8/25/2011 10:52:47 AM:      Execution started.

8/25/2011 10:52:47 AM:      QlikView Version:9.00.7646.9

8/25/2011 10:52:47 AM: 0002  SET ThousandSep=','

8/25/2011 10:52:47 AM: 0003  SET DecimalSep='.'

8/25/2011 10:52:47 AM: 0004  SET MoneyThousandSep=','

8/25/2011 10:52:47 AM: 0005  SET MoneyDecimalSep='.'

8/25/2011 10:52:47 AM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

8/25/2011 10:52:47 AM: 0007  SET TimeFormat='h:mm:ss TT'

8/25/2011 10:52:47 AM: 0008  SET DateFormat='M/D/YYYY'

8/25/2011 10:52:47 AM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

8/25/2011 10:52:47 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

8/25/2011 10:52:47 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

8/25/2011 10:52:47 AM: 0013  ODBC CONNECT*XUserId*XPassword*

8/25/2011 10:52:47 AM: 0021  SQL SELECT *

8/25/2011 10:52:47 AM: 0022  FROM S102LAPM.JDEINTLIB.F5682QV

8/25/2011 10:52:48 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/25/2011 10:52:52 AM:       Error: ODBC read failed

8/25/2011 10:52:54 AM: 0026  If ScriptErrorCount = 0 then

8/25/2011 10:52:55 AM:      Execution finished.

[Anonymous]

Hello,

I have the same problem with Unicode characters.

I have a SQL server database which is contain of a large data where most of them are Unicode and has the nchar data type.

Unfortunately when i load them by LOAD SQL statement , it shows "?????" instead of the Unicode texts.

Also I changed Windows language and setting but nothing changed.

[Anonymous]

Hello,

I solved my problem by creating second Table with Nvarchar Type In sql server as this:

IF EXISTS(SELECT * FROM   NewTbl)

DROP TABLE NewTbl

SELECT

field1,field2,,

convert(nvarchar(50),Field3) Field3

INTO [MyDb].dbo.NewTbl

FROM [MyDb].dbo.PreviousTbl;