HI, We have Forms 6i, we are going for Multilingual, and it has Oracle 11g db. We are updating the database with one more column in an exiting table with NVarchar2. The approach we are going for Column level Character set Updates. One more approach is Full Database level Character Set. I try to compile a Forms 6i it has oracle 11g database, it has a column has type with NVarchar2, it Says Character set not supportive, for that forms level what all the set up need to do? I had set change for NLS NLS_LANGUAGE=SIMPLIFIED CHINESE NLS_TERRITORY=CHINA NLS_CHARACTERSET=ZHS16GBK NLS_NCHAR_CHARACTERSET=USASCII7 And NLS setting in REGEDIT SIMPLIFIED CHINISE_CHINA.ZHS16CGB231280 Also done. Still I have problem of 1. Compiling. If I compile with VARCHAR2, then use that same form, it does not identifying. If I try to COST VARCHAR2 or CHAR to NVARCAHR2 then also it’s not identifying. 2. I try to insert the Chinese String from Backend with some editor, the data are getting into database, while selecting it comes as '?????????'. We are looking what we can do for an application level. Type Cost or any method are available Thanks, Guru.

Software/Hardware used: