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 <lex.de.haan@xxxxxxxxxxxxxx> wrote: > > check out the globalization support documentation -- there are many things > that can go wrong :-) > check out > http://www.oracle.com/pls/db92/db92.to_toc?pathname=server.920%2Fa96529%2Ftoc.htm&remark=docindex > are you using Unicode? what's the setting of the NLS_LANG variable? ... > > kind regards, > > Lex. > > --------------------------------------------------------------------- > Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html > --------------------------------------------------------------------- > > ------------------------------ > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Onkar N Tiwary > *Sent:* Friday, October 28, 2005 09:17 > *To:* oracle-l@xxxxxxxxxxxxx > *Subject:* Oracle Installation in Hebrew > > Hi folks, > 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????? > TIA > > -- > Thanks & Regards, > T. Onkar Nath > OneAPPS Enterprise Technology Pvt. Ltd. > to_onkar@xxxxxxxxx > onkarnath.tiwary@xxxxxxxxx > > -- Thanks & Regards, T. Onkar Nath OneAPPS Enterprise Technology Pvt. Ltd. to_onkar@xxxxxxxxx onkarnath.tiwary@xxxxxxxxx