Link to home
Start Free TrialLog in
Avatar of kalmen
kalmen

asked on

Displaying Arabic/Hebrew Characters

Hi,

I'm new to oracle. I've developed web applications using oracle as a backend but never for non-english text. Now I have an application that has Arabic/Hebrew (not a mix, but two separate applications.)

In SQL Plus it only displays '????????' and even on the webpage. I'm sure the data is intact because I've seen it display correctly in someone else's computer.

Thanks.
Avatar of Metanil
Metanil
Change the database NLS parameter .. LIke
NLS_LANGUAGE=Arabic
NLS_CHARACTERSET = <your desire type>

Metanil
Avatar of Metanil
Metanil
nls_characterset for arabic and hebrew are:

IW8MSWIN1255                             MS Windows Code Page 1255 8-bit Latin/Hebrew

AR8MSWIN1256                             MS Windows Code Page 1256 8-Bit Latin/Arabic
Avatar of Metanil
Metanil
Sorry,

AR8ISO8859P6                            ISO 8859-6 Latin/Arabic SB, ASCII

IW8ISO8859P8                            ISO 8859-8 Latin/Hebrew
Avatar of kalmen
kalmen

ASKER

Hi All,

I tried for Arabic the following: AMERICAN_AMERICA.AR8MSWIN1256
which displays both arabic and english, which works on my windows xp machine but not on my windows 2000 server. Any thoughts?
Avatar of Metanil
Metanil
change the NLS parameter in your registry of your windows 2000

Metanil
Avatar of kalmen
kalmen

ASKER

I did. I put it everywere that had NLS_LANG but it still didn't work. Am I missing anything?
Avatar of Metanil
Metanil
is Windows 2000 is your database server or client??
Avatar of kalmen
kalmen

ASKER

Its my client. My database is on a Unix Box.
Avatar of Metanil
Metanil
if u are using SQL plus then you can explicitly change the language by issuing
SQL>ALTER SESSION SET NLS_LANG='<...>'

or

you can change the language in the database server in that particuar database instance to make global change.

Metanil
Avatar of kalmen
kalmen

ASKER

I'm sorry, I couldn't do either, I don't have privellage. Its working fine for me on WinXP and everyone else. We defined the nls_lang in the registry for it to work, but on the win2k box I'm working on, nothing seems to work, it just gives me nonsense. See:

SQL> select name_a from business_card where rownum < 5;

NAME_A
--------------------------------------------------------------------------------
æÇÆÜÜá ãÚíÜä ÕÇáÜÜÜÍ
ÍÓíä ÇáåäÏÇæí
Úáí ÕÏíÞ ÎæÇÌå
áíä ÅíäæÓ ãÝæÑæ
ASKER CERTIFIED SOLUTION
Avatar of Metanil
Metanil
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oleggold
oleggold
Flag of United States of America image
from an expirience for hebrew charset on client NLS_LANGUAGE=HEBREW_ISRAEL.IW8ISO8859P8 IN HKLM\SOFTWARE\ORACLE\HOME# allways works,You need to change it in any home You're using the app.(e.g. SQLPLUS).
SOLUTION
Avatar of oleggold
oleggold
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kalmen
kalmen

ASKER

Dear All,

It turns out that I have a problem with the software and need to reinstall with newer release. Thanks for your help all.