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

[#1]

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

[hic]

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

[#3]

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

[agilos_mla]

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

[hic]

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

[#6]

no its don't work

[#7]

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