6 Replies Latest reply: Feb 26, 2007 10:56 AM by 67800 RSS

    Languages supported for IW8ISO8859P8

    67800
      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
          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
            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
              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
                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
                  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
                    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.