After I set my database using NLS_NCHAR_CHARACTERSET = UTF16, chinese character can be inserted successfully. However, chinese character cannot be display correctly in SQL PLUS using simple SQL select statement. (I'm using Windows 2000 Professional - English edition)
I have already try to set the registry value for NLS_LANG to AMERICAN_AMERICA.UTF8, AMERICAN_AMERICA.ZHT16MSWIN950, AMERICAN_AMERICA.ZHT16BIG5, TRADITIONAL CHINESE_TAIWAN.UTF8, TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950, TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5. However, none of them can solve the problem.
Of course you will definitely need to try it out on a test machine first.
However, I would not forsee any issues if you just want to view Chinese characters from SQLPLUS on your PC.
Unless you have a real requirement to view Chinese characters on the application server which is acting as the Oracle client to query the database server.
By installing chinesse in the windows regional settings for client PC, even SQLPLUS from a telnet session can view chinese characters correctly.
From my personal experience, our apps server is the client connecting to the datbase server(Traditional Chinese,TAIWAN), which is in English windows. Users accessing the apps server need to view Chinese data when they query data. So we end up installing Traditional Chinese onto the users windows PC regional setting.
Once Traditional Chinese is installed to the user's PC, they can still view both English & Traditional Chinese.