4 Replies Latest reply: Mar 8, 2013 8:05 AM by Zoltan Kecskemethy RSS

    choosing nls_lang for oracle 11g

    710716
      Both of my server and client have thier nls_lang = AL32UTF8 , but my client os has different character set , is this will cause problem or the unicode will handle all other coding.
        • 1. Re: choosing nls_lang for oracle 11g
          sb92075
          user11174536 wrote:
          Both of my server and client have thier nls_lang = AL32UTF8 , but my client os has different character set , is this will cause problem or the unicode will handle all other coding.
          no problem with this combination
          • 2. Re: choosing nls_lang for oracle 11g
            710716
            no problem with this combination
            I am confused with what was said in this link  http://www.dba-oracle.com/t_nls_lang.htm
            suppose that the database character set is AL32UTF8, the client is an English Windows >operating system, and the NLS_LANG setting on the client is AL32UTF8. Data coming into >the database is encoded in WE8MSWIN1252 and is not converted to AL32UTF8 data >because the NLS_LANG setting on the client matches the database character set. Thus >Oracle assumes that no conversion is necessary, and invalid data is entered into the >database.
            • 3. Re: choosing nls_lang for oracle 11g
              Sergiusz Wolicki-Oracle
              All depends on your client operating system and the applications you use with this system. Some applications will not care about NLS_LANG at all. Some will need NLS_LANG configured to the character set of data that Oracle Client libraries receive. On Windows, some applications may need one NLS_LANG value and other applications may need a different one -- depending on the GUI vs console subsystem in use. You need to provide exact details of your client environment, including O/S language settings, for me to be able to recommend a particular NLS_LANG value.

              -- Sergiusz
              • 4. Re: choosing nls_lang for oracle 11g
                Zoltan Kecskemethy
                You may want to read the following My Oracle Support documents.
                [url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=179133.1]The correct NLS_LANG in a Windows Environment Doc ID 179133.1,
                [url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=264157.1]The correct NLS_LANG setting in Unix Environments Doc ID 264157.1