This content has been marked as final. Show 5 replies
SELECT value FROM nls_database_parameters WHERE parameter='NLS_CHARACTERSET';
because the server operating-system and oracle datebase are both installed in Japanese, I can not insert Chinese character as well, so I have to choose nvarchar2, when I create a new table with Nvarchar2, it seemed worked with plsql developer and toad inserting Chinese characters , but not in apex webpage I created.
So, I think there may be some configurations I can recheck about APEX.
Can you give me some advises?
I doubt Apex will work well with NVARCHAR2 columns. First, you need to have RAW mode enabled on embedded PL/SQL gateway (transfer-mode DAD attribute set to 'raw'). This may enable NVARCHAR2 support on the OWA level (though I have never tested this). However, Apex may store various GUI content in VARCHAR2 intermediate variables, causing implicit conversion and loss of Chinese characters. You should migrate your database to AL32UTF8 to support both Chinese and Japanese.
Note that Unicode unifies some of Han/Kanji ideographic characters. To get correct display in Chinese and Japanese, you may need to set the HTML 'lang' tag of your page and/or fonts correctly to force the browser to select either the Chinese or Japanese font, as appropriate for the displayed content.