Re: Oracle Installation in Hebrew

Use we8iso8859p8 for hebrew characters.
We used P1 and now start a project to convert to P8, because P1 and dot.net does not work together.

If you are are using P1 check the settings for the client. If it is not P1 sql*net will do conversion and the hebrew will not come out right.

Adar Yechiel
Rechovot, Israel

Onkar N Tiwary wrote:

> 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_at_naturaljoin.nl
> <mailto:lex.de.haan_at_naturaljoin.nl>> 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
> <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_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org> [mailto:
> oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>] *On Behalf Of *Onkar N Tiwary
> *Sent:* Friday, October 28, 2005 09:17
> *To:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *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_at_yahoo.com <mailto:to_onkar_at_yahoo.com>
> onkarnath.tiwary_at_gmail.com <mailto:onkarnath.tiwary_at_gmail.com>
>
>
>
>
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar_at_yahoo.com <mailto:to_onkar_at_yahoo.com>
> onkarnath.tiwary_at_gmail.com <mailto:onkarnath.tiwary_at_gmail.com>

--
http://www.freelists.org/webpage/oracle-l