Home » SQL & PL/SQL » SQL & PL/SQL » Problem in Storing Arabic Characters in DB
Problem in Storing Arabic Characters in DB [message #184374] Wed, 26 July 2006 06:34 Go to next message
sathiyapriya_rv
Messages: 10
Registered: July 2006
Junior Member
Hi All,

We are storing English,Arabic characters in our DB.

Following are the Nls_Parameters in the DB:
PARAMETER VALUE
------------------------ --------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LENGTH_SEMANTICS CHAR
NLS_NCHAR_CONV_EXCP FALSE


The Problem is ,if i check the arabic data in sqlplus or toad ,is shows some junk characters.

Example(It shows like this in sqlplus)
LAST_NAME_ARABIC
------------------------------
真真 真真 真真 真真真
真真 真真真 真真真 真真真真
真真 真真
真 真 真真 真真真


But if i access the through application(which is developed in java/J2ee) ,it showing perfectly.
It means that,its storing Arabic data properly,But i can't view the Arabic data in sqlplus.Any Solutions????


Re: Problem in Storing Arabic Characters in DB [message #189590 is a reply to message #184374] Fri, 25 August 2006 03:16 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Could it be that Your CLIENT nls settings does not match Your database's nls?

Have You checked that Your J2EE application is set correctly?
Is Your Oracle client also set up correctly?

Br
Kim
Re: Problem in Storing Arabic Characters in DB [message #189679 is a reply to message #184374] Fri, 25 August 2006 09:48 Go to previous messageGo to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi,

I did a try in my settings and it worked,
Try like this in

Start > run >regedit > select software then select ORACLE and (first see the value there and after . enter this thing it should work AR8MSWIN1256).

What is your Operating System and Oracle Version.
Check for OS language setting also if this doesn't works.


Regards
Re: Problem in Storing Arabic Characters in DB [message #189780 is a reply to message #184374] Sun, 27 August 2006 07:30 Go to previous messageGo to next message
farahat
Messages: 14
Registered: August 2006
Location: sudan
Junior Member

in install oracle or in orahome choose the protect language and then choose arabic language .
another method remove the arabic languge from the system befor install oracle .



thank
Re: Problem in Storing Arabic Characters in DB [message #189781 is a reply to message #189679] Sun, 27 August 2006 07:34 Go to previous message
farahat
Messages: 14
Registered: August 2006
Location: sudan
Junior Member

operating system will do that win xp
and oracle ver is 8i or greator

thank
Previous Topic: Procedure locks (merged)
Next Topic: diffrent between a prameter
Goto Forum:
  


Current Time: Sun Dec 11 03:53:55 CST 2016

Total time taken to generate the page: 0.05759 seconds