DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2000
    Hi all

    I installed personal oracle 8i on win98. My win98 is hebrow enable, and my oracle is in hebrow. I tryed to change the nls_lang to AMERICAN_AMERICA.IW8ISO8859P8 but no good(as i thought it would be, but i had to try)

    Can any one out there tell me how to convert my oracle to English? do i need to re-install it, or gust change a few parameters


  2. #2
    Join Date
    Jun 2000
    For the database , you will need to create a new database with the new character set , you can not change a database character set after its created.

    If you have work on the old database , just make and export dump file and re import it to the New one.

    Also get to the windows registry ( Software / Oracle section ) select NLS_LANG key , chang it to the character set you want then restart windows , you should work correctly Now.
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.