This content has been marked as final. Show 4 replies
no problem with this combinationI 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.
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.
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