topic Re: please help me to load data from database collation &quot;Arabic_CI_AS&quot; in QlikView https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619059#M682592 <HTML><HEAD></HEAD><BODY><P>yes i load the data but the Arabic column display as ???? ???? so how to fix this problem please </P></BODY></HTML> Sat, 22 Feb 2014 21:40:20 GMT 2014-02-22T21:40:20Z please help me to load data from database collation "Arabic_CI_AS" https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619057#M682590 <HTML><HEAD></HEAD><BODY><P>please help me to load data from database collation "Arabic_CI_AS" </P></BODY></HTML> Fri, 21 Feb 2014 15:43:53 GMT https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619057#M682590 2014-02-21T15:43:53Z Re: please help me to load data from database collation "Arabic_CI_AS" https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619058#M682591 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Finally, the collation: It affects sort orders and searches. See more on <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/02/collation" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/02/collation">http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/02/collation</A></P><P></P><P>HIC</P></BODY></HTML> Sat, 22 Feb 2014 10:24:58 GMT https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619058#M682591 hic 2014-02-22T10:24:58Z Re: please help me to load data from database collation "Arabic_CI_AS" https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619059#M682592 <HTML><HEAD></HEAD><BODY><P>yes i load the data but the Arabic column display as ???? ???? so how to fix this problem please </P></BODY></HTML> Sat, 22 Feb 2014 21:40:20 GMT https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619059#M682592 2014-02-22T21:40:20Z Re: please help me to load data from database collation "Arabic_CI_AS" https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619060#M682593 <HTML><HEAD></HEAD><BODY><P>As Henric said make sure your ODBC is setup with UTF8 an try to force the collation in the SQL statement </P><P></P><P style="font-size: 11pt; font-family: Calibri, sans-serif; color: #000000; font-weight: bold; background-color: #eeeeee;"><SPAN style="font-family: 'Courier New'; font-size: 10pt; color: blue;">LOAD *;<BR /></SPAN></P><P style="font-size: 11pt; font-family: Calibri, sans-serif; color: #000000; font-weight: bold; background-color: #eeeeee;"><SPAN style="font-family: 'Courier New'; font-size: 10pt; color: blue;">SQL select</SPAN><SPAN style="font-family: 'Courier New'; font-size: 10pt;"> ProductID<SPAN style="color: gray;">,</SPAN></SPAN></P><P style="font-size: 11pt; font-family: Calibri, sans-serif; color: #000000; font-weight: bold; background-color: #eeeeee;"><SPAN style="font-family: 'Courier New'; font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProductName <SPAN style="color: blue;">COLLATE</SPAN> SQL_Arabic_CI_AS</SPAN></P><P style="font-size: 11pt; font-family: Calibri, sans-serif; color: #000000; font-weight: bold; background-color: #eeeeee;"><SPAN style="font-family: 'Courier New'; font-size: 10pt; color: blue;">from</SPAN><SPAN style="font-family: 'Courier New'; font-size: 10pt;"> AdventureWorks<SPAN style="color: gray;">.</SPAN>Production<SPAN style="color: gray;">.</SPAN>Product</SPAN></P></BODY></HTML> Sat, 22 Feb 2014 21:53:36 GMT https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619060#M682593 agilos_mla 2014-02-22T21:53:36Z Re: please help me to load data from database collation "Arabic_CI_AS" https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619061#M682594 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>Arabic is no problem for QlikView if the connection is OK.</P><P></P><P>HIC</P><P></P><P><IMG alt="Arabic.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53671_Arabic.png" /></P></BODY></HTML> Sat, 22 Feb 2014 21:56:32 GMT https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619061#M682594 hic 2014-02-22T21:56:32Z Re: please help me to load data from database collation "Arabic_CI_AS" https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619062#M682595 <HTML><HEAD></HEAD><BODY><P>no its don't work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Sat, 22 Feb 2014 22:15:18 GMT https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619062#M682595 2014-02-22T22:15:18Z Re: please help me to load data from database collation "Arabic_CI_AS" https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619063#M682596 <HTML><HEAD></HEAD><BODY><P>i load from OLE DB from server <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">collation "Arabic_CI_AS"</SPAN> here i have the problem but when i load from Excel or another collation it's work correct </P></BODY></HTML> Sat, 22 Feb 2014 22:17:27 GMT https://community.qlik.com/t5/QlikView/please-help-me-to-load-data-from-database-collation-quot-Arabic/m-p/619063#M682596 2014-02-22T22:17:27Z