Setting NLS_LANG correctly enables proper conversion from the client operating system character encoding to the database character set. The character set that is specified by the NLS_LANG parameter should reflect the setting for the client operating system.
Setting the NLS_LANG parameter properly is essential to proper data conversion.
If you are using characters outside this set, then take care that your data is supported in the database character set that you have chosen. The following control characters: space, horizontal tab, vertical tab, form feed The following punctuation marks: % ' ' ( ) * +. Uppercase and lowercase English characters A through Z and a through z The following CHAR and VARCHAR characters are represented in all Oracle Database character sets and can be transported to any platform: Even now there can be problems using certain characters across platforms. When character sets were first developed, they had a limited character repertoire.
Because character sets are typically based on a particular writing script, they can support multiple languages. Different character sets support different character repertoires.
