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.
I have character set WE8ISO8859P1 on my data base server which is a linux box
I have AL16UTF16 as national character set.
On my windows XP client currect NLS_LANG is AMERICAN_AMERICA.WE8MSWIN1252
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 at the same time and also english.
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