Solved

Arabic Support in Oracle 8i

Posted on 2001-06-23
5
1,038 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

831 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