Solved

Arabic Support in Oracle 8i

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Listener Not Starting 11 66
Oracle dataguard 5 61
Oracle Query - Convert letters to numbers and display the difference 3 45
oracle sqlplus query delimiter 8 39
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
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…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

733 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