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@xxxxxxxxxxxxxx <mailto: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
<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> [mailto:
    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 <mailto: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 <mailto:to_onkar@xxxxxxxxx>
onkarnath.tiwary@xxxxxxxxx <mailto:onkarnath.tiwary@xxxxxxxxx>





-- Thanks & Regards, T. Onkar Nath OneAPPS Enterprise Technology Pvt. Ltd. to_onkar@xxxxxxxxx <mailto:to_onkar@xxxxxxxxx> onkarnath.tiwary@xxxxxxxxx <mailto:onkarnath.tiwary@xxxxxxxxx>


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


Other related posts: