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