This discussion is archived
6 Replies Latest reply: Feb 26, 2007 8:56 AM by 67800 RSS

Languages supported for IW8ISO8859P8

67800 Newbie
Currently Being Moderated
Hi, wondering if anyone knows what are the languages supported for IW8ISO8859P8

E.g.:
NLS_LANG=AMERICAN_AMERICA.IW8ISO8859P8
NLS_LANG=HEBREW_ISRAEL.IW8ISO8859P8

any others besides the above two?
  • 1. Re: Languages supported for IW8ISO8859P8
    orafad Oracle ACE
    Currently Being Moderated
    The language, territory settings and character set indicator are really separate. The last one, the char set part, is used to let Oracle know which encoding your environment is using, so conversion from and to database can be done properly.

    I suggest you read the following chapter about setting locale behaviour:
    http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch3globenv.htm

    This one may be useful too:
    http://czyborra.com/charsets/iso8859.html

    edit:
    added the Alphabet soup url.

    Message was edited by:
    orafad
  • 2. Re: Languages supported for IW8ISO8859P8
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    IW8ISO8859P8 supports Hebrew, most probably other Jewish languages such as Yiddish, and all languages that use ASCII letters only. Languages using ASCII only are English, Latin, Swahili (and some other Bantu languages), Indonesian, Dutch, and possibly many other.

    Support for storing the language does not mean support as NLS_LANG setting. For example, Oracle does not support Latin language or Swahili, i.e. it cannot display Latin or Swahili month names, etc.


    -- Sergiusz
  • 3. Re: Languages supported for IW8ISO8859P8
    67800 Newbie
    Currently Being Moderated
    Thanks S. Wolicki for the reply. I think it is helpful. It's not that I didnt' read the documents, but it seems to me that even I changed the setting to something else, it's the same as AMERICAN_AMERICA.
    So even we changed it to AMERICAN_ISRAEL, there is no effect there as we want to read english but adpot ISRAEL date format.
  • 4. Re: Languages supported for IW8ISO8859P8
    orafad Oracle ACE
    Currently Being Moderated
    Note sure which date format you'd like. But such change is noticable at least like in the following:
    SQL> select * from nls_session_parameters;
    
    PARAMETER                      VALUE
    ------------------------------ -----------------------------
    NLS_LANGUAGE                   SWEDISH
    NLS_TERRITORY                  SWEDEN
    NLS_DATE_FORMAT                RRRR-MM-DD
    NLS_DATE_LANGUAGE              SWEDISH
    
    SQL> alter session set nls_territory='Israel';
    Session är ändrad.
    
    SQL> select * from nls_Session_parameters;
    
    PARAMETER                      VALUE
    ------------------------------ -----------------------------
    NLS_LANGUAGE                   SWEDISH
    NLS_TERRITORY                  ISRAEL
    NLS_CURRENCY                   ¿"¿
    NLS_ISO_CURRENCY               ISRAEL
    NLS_DATE_FORMAT                DD-MON-RRRR
    NLS_DATE_LANGUAGE              SWEDISH
    
    SQL> select sysdate from  dual;
    
    SYSDATE
    -----------
    23-FEB-2007
  • 5. Re: Languages supported for IW8ISO8859P8
    Sergiusz Wolicki (Oracle) Expert
    Currently Being Moderated
    If you change territory to ISRAEL in the NLS_LANG, the default date format will become DD-MON-RRRR (unless you also set NLS_DATE_FORMAT to something else). But what corresponds to MON, which is month name abbreviation, depends on NLS_DATE_LANGUAGE, which defaults to language part of NLS_LANG. Therefore, to see Hebrew month abbreviations you need to set NLS_LANG to HEBREW_ISRAEL or set NLS_DATE_LANGUAGE=HEBREW along with NLS_LANG.

    Also, Hebrew letters of the month abbreviation will display correctly only if:

    * the database character set is IW8<something> or AL32UTF8 or UTF8, and
    * the NLS_LANG character set is IW8<something> or AL32UTF8 or UTF8, and
    * the client is configured to display the character set used in NLS_LANG.


    -- Sergiusz
  • 6. Re: Languages supported for IW8ISO8859P8
    67800 Newbie
    Currently Being Moderated
    S. Wolicki,
    You hit the problem right on. Actually I was doing this on the app server instead on the database for Oracle Forms. Found the solution by adding NLS_DATE_LANGUAGE = HEBREW environment variable. So even though we changed it to AMERICAN_ISRAEL that won't be effective unless changing NLS_DATE_LANGUAGE.