NLS_LANG in case of Japanese data
Hi,
My DB NLS Charset is AMERICAN_AMERICA.AL32UTF8 and NLS_LENGTH_SEMANTICS is BYTE. I am working with Japanese Kanji, Kana Data. I am storing japanese data into VARCHAR2. I am using SQL*LOADER to load japanese data into Oracle Tables.
When I upload data using SQLLDR with NLS_LANG=AMERICAN_AMERICA.AL32UTF8 then I am facing Data Too Large Exception. But When I upload data with NLS_LANG=AMERICAN_AMERICA.JA16SJIS then my data is uploaded successfully.
Please tell me AMERICAN_AMERICA.JA16SJIS is perfect charset to upload data into oracle tables?
If not then please tell me how to upload japanese data using AMERICAN_AMERICA.AL32UTF8 charset.
My DB Table is given below:
CREATE TABLE TEST_KANJI
(
DATA_TEST1 VARCHAR2(5 CHAR),
DATA_TEST2 VARCHAR2(5 CHAR)
);