Configuring my machine for Arabic(multi-lingual) in Oracle

select
to_char(sysdate,'day dd month yyyy',

'nls_calendar=''Arabic Hijrah'''),
to_char(sysdate,'day dd month yyyy',

'nls_calendar=''English Hijrah'''),
to_char(sysdate,'day dd month yyyy',

'nls_calendar=''gregorian''')

from dual;

I get the results:-

¿¿¿¿¿¿¿¿ 06 ¿¿¿¿ ¿¿¿¿¿¿ 1436 ¿¿¿¿¿¿¿¿ 06 Rabi' Thani 1436 ¿¿¿¿¿¿¿¿ 27 ¿¿¿¿¿ 2015

The question marks here show me that Oracle is not configured for Arabic. I have trie various tutorials and suggesstions. I tried setting the environment variable, NLS_LANG( both system and user) to "american_america.ar8mswin1256".

I also changed the language of my system to Arabic(Saudi Arabia), but still in vain.

Any ideas? Any mistake that I am making. I still think that the changes have to be made on my remote machine rather than the host machine, which I do not have access to.

If there is any video tutorial available on youtube, please past it here so that would make my task easier. Received on Tue Jan 27 2015 - 11:06:25 CET