Solved

Arabic Support in Oracle 8i

Posted on 2001-06-23
5
1,030 Views
Last Modified: 2011-09-20
Hi friends,

   How can i store nd retrieve ARABIC words in Oracle 8i..? should i have to download any translators for that..?

please give me a detailed info on that..

thanks..

Jim

 
0
Comment
Question by:jimaricat072100
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:RMZ
ID: 6221112
hi
when u create your database select nls_lang=ar8iso8859p6
and in client (regedit nls_lang=AMERICAN_AMERICA.AR8MSWIN1256
--rmz---
0
 
LVL 2

Accepted Solution

by:
noriegaa earned 100 total points
ID: 6222003
I believe you could better servered with UTF8 for borth the NLS_NATIONAL_CHARACTER and NLS_CHARACTER parameters, and defining usijng nvarchar2 data types whenever convenient.  If you have any Java applications, you need to use the JDBC-OCI driver, and could look at Oracle's usage of Java's resource bundling for further localization support.  It is convenient to define the NLS parameters when one creates the database, since commands such as "alter database set nls_character set <nls_character_set name>;" work based if the existing character is inclusive - i.e., a subset of- in the new character set both logically and physically.
There is a good manual on National Language Support for each 8i release.

Cheers.

--Anthony
0
 
LVL 2

Expert Comment

by:RMZ
ID: 6222410
HI
i'm use 8,8i with arabic support
all i do when installing database select characterset  to be AR8ISO8859P5 so the database can store arabic
to retrive arabic on client from regedit
local_machine\software\oracle
nls_lang=AMERICAN_AMERICA.AR8MSWIN1256
so i can retrive arabic
---rmz---
0
 
LVL 1

Author Comment

by:jimaricat072100
ID: 6223456
Thanks noriegaa for u'r great answer. I will try with that u mentioned..thanks anyway..
cheers..
0
 
LVL 1

Author Comment

by:jimaricat072100
ID: 6223459
thanku rmz for u r support
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now