Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: Change the Language of message box

    Hi everybody
    I want to know how I can change the language of the massage boxes in oracle data base. For example I have a database with Arabic language, how I can see messages in English form.
    Im so thankful if you can help me

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    If you're talking about the language in which Oracle messages are displayed, then you can modify your NLS_LANG environment variable. It is made of 3 parts :

    LANGUAGE_TERRITORY.CHARSET

    LANGUAGE : the language in which Oracle messages are dirsplayed (the part you seem to be interested in right now)

    TERRITORY : impacts local date format, default sort operations, default timezone...

    CHARSET : The client character set. Oracle uses this value to convert string data from the DB character set to the Client character set so that these data are correctly interpreted and displayed by the client.

    For example :

    AMERICAN_AMERICA.UTF8
    FRENCH_FRANCE.WE8ISO8859P1 (west european latin-1)
    ARABIC_ALGERIA.AR8ISO8859P6 (ISO 8859-6 Latin/Arabic)
    AMERICAN_ALGERIA.UTF8

    Here is the list of supported languages and here is the list of supported territories.

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

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