| Problem in Storing Arabic Characters in DB [message #184374] |
Wed, 26 July 2006 06:34  |
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 #189679 is a reply to message #184374] |
Fri, 25 August 2006 09:48  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
