[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Arabic Support in Oracle 8i

Posted on 2001-06-23
5
Medium Priority
?
1,060 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 300 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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 Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

656 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