Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Installation in Hebrew

RE: Oracle Installation in Hebrew

From: Jacques Kilchoer <>
Date: Fri, 28 Oct 2005 11:52:07 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262119FCED@irvmbxw02>

Several questions.
a) What is the operating system of the client machine? Windows 2000 I assume, from your e-mail.
b) What program is being used on the client machine to store and receive data?
c) Is the program in b) a UNICODE program? d) The WE8ISO8859-1 character set does not allow hebrew characters, only western european characters. What is the datatype of the columns in which you are trying to store the hebrew characters? e.g. are they VARCHAR2 or NVARCHAR2?  

A little background:
suppose I want to store hebrew characters in varchar2 columns in my Oracle database from a non-Unicode program (like SQL*Plus) running on Windows. Here are the steps:  

  1. Create a database with a character set that supports hebrew characters, e.g. IW8ISO8859P8 or IW8MSWIN1255 or UTF8.
  2. Set the code page of my Windows machine to be a Hebrew code page. Go into the Regional Options Control Panel, and choose Hebrew (the exact spot where you choose Hebrew in the Regional Options control panel will be different depending on Windows version, 2000 vs. XP etc.) Step 2) can be skipped if your client program is a Unicode program.
  3. Set my NLS_LANG, FOR THE ORACLE_HOME THAT MY CLIENT PROGRAM WILL BE USING, so that the encoding value (character set value, the portion after the period in NLS_LANG) corresponds to your WINDOWS CODE PAGE. This is very important. Any client program will have to have a correct setting for NLS_LANG.

De :
[] De la part de Onkar N Tiwary

hi lex,  

thanx for the quick response. NLS_LANG is AMERICAN_AMERICA. Character set is WE8ISO8859P1 and NATIONAL_CHARACTER_SET is UTF8  

On 10/28/05, Lex de Haan <> wrote:         

        check out the globalization support documentation -- there are many things that can go wrong :-)

        check out 2Ftoc.htm&remark=docindex          

        are you using Unicode? what's the setting of the NLS_LANG variable? ...

        From: [mailto: <> ] On Behalf Of Onkar N Tiwary

        Sent: Friday, October 28, 2005 09:17                            

        I am running oracle 9i on windows 2000 professional. client wanted to store data in hebrew and so i installed the db in english and hebrew both (using product language option of OUI) but after installation , when the user is the storing hebrew data in the table and trying to access the data its showing junk characters. any idea?????          

Received on Fri Oct 28 2005 - 13:54:18 CDT

Original text of this message