Solved

Arabic Support in Oracle 8i

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

785 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