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

From: wE|rd0 <amirediwan_at_gmail.com>
Date: Tue, 27 Jan 2015 02:06:25 -0800 (PST)
Message-ID: <e432dc19-7940-4d46-babf-c8f5e47b6c7f_at_googlegroups.com>



I am using Oracle 11g. On running the query:-

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

Original text of this message