DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Oct 2000
    This might seem silly but can I create a DB which supports all the languages - eg. FRENCH, CHINESE, ENGLISH.
    Can I change the NLS_LANG parameter without bouncing the DB.. ?



  2. #2
    Join Date
    Jun 2000
    You can change NLS_LANGUAGE with an alter session statement, or you can change your NLS_LANG environment variable without bouncing the db.

  3. #3
    Join Date
    Sep 2000
    By changing NLS_LANG you would not help yourself to support all those languages if your character set is default us7ascii.
    Do select * from nls_database_parameters;
    look for NLS_CHARACTERSET and if it is US7ASCII or anything else but UTF8 you can not support FRENCH, CHINESE, ENGLISH together in one database.
    If you are on oracle 8i and your database's character set is us7ascii you can follow instructions from NLS Support Guide on using ALTER DATABASE SET CHARACTERSET command to move from us7ascii to UTF8. If you are not on Oracle 8i and/or your characater set is not us7ascii, you have to rebuild database to move from your current character set to UTF8. But I suggest you read first if you need to have a database that supports all those languages. Two many options and you may make a wrong decision :-)
    Alla S. Pfauntsch
    Oracle DBA
    "Life is what happens while you are planning something else".

  4. #4
    Join Date
    Oct 2000
    Thanx..my db is on oracle8i (8.1.5) on Sun. I just wanted the info before creating my database. We were just trying out the possibilities.
    Would be grateful if you could provide some more info on the same.


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.