Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

please help me to load data from database collation "Arabic_CI_AS"

please help me to load data from database collation "Arabic_CI_AS"

6 Replies
Henric_Cronström

You need to check your ODBC/OLEDB connection and make sure that Unicode or UTF8 is used. Then QlikView will load the data including arabic characters without problem. To display it, you need to choose a font (in the list box or chart) that is able to show UTF8.

Finally, the collation: It affects sort orders and searches. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/02/collation

HIC

Not applicable
Author

yes i load the data but the Arabic column display as ???? ???? so how to fix this problem please

agilos_mla
Partner
Partner

As Henric said make sure your ODBC is setup with UTF8 an try to force the collation in the SQL statement

LOAD *;

SQL select ProductID,

         ProductName COLLATE SQL_Arabic_CI_AS

from AdventureWorks.Production.Product

Henric_Cronström

Do you load from ODBC or OLEDB? Then you need to check the properties of the connection. Or do you load from a text file? The check that the text file is UTF8 and that it says UTF8 in the Load statement in the script.

Arabic is no problem for QlikView if the connection is OK.

HIC

Arabic.png

Not applicable
Author

no its don't work

Not applicable
Author

i load from OLE DB from server collation "Arabic_CI_AS" here i have the problem but when i load from Excel or another collation it's work correct