NLS Settings
Hi
i have an oracle 9.2.0.6 data base on a linux machine and on the client side i have windoes XP. i have to insert data in the database with national character set AL16UTF16; data in different languages suppose GREEK and ARABIC.
1) What setting do i need in my windows environment for NLS_LANG. current value of this is "AMERICAN_AMERICA.WE8MSWIN1252" should i set it to "AMERICAN_AMERICA.UTF8" to support both languages.
2) If i export from this database, at that time, should i set the NLS_LANG to "AMERICAN_AMERICA.UTF8" to avoid data loss during export???
3) Is character set mentioned in NLS_LANG is used to encode the data on the client side and then it is sent on server side? and in case i have AMERICAN_AMERICA.UTF8, it can insert data in any language in my application and it would be inserted correctlt in a column having NVARCHAR2 Data type.
4) What is diffrence in AL16UTF16 National character set and UTF8 Character Set
Regards
Message was edited by:
Salman Qureshi