I read some posts here on how to input chinese and display chinese correctly on both client and server side.
I think both NLS_CHAR_CHARACTERSET and NLS_NCHAR_CHARACTERSET should be changed to UTF8. Is that right?
I tried to do it by issuing "ALTER SESSION SET NLS_NCHAR_CHARACTERSET" in SQL*Plus but it has such response:
SQL> ALTER SESSION SET NLS_NCHAR_CHARACTERSET='UTF8';
ALTER SESSION SET NLS_NCHAR_CHARACTERSET='UTF8'
ERROR at line 1:
ORA-00922: missing or invalid option
Actually I have to design an web interface (using JDBC-ODBC to connect to the database) to allow others to input chinese and then store them into database. Do I need to alter for each session for each update?
At your first questions the answer is almost TRUE. It can be done by altering the CHARACTER SET and NATIONAL CHARACTER SET of the database. Mostly it depends of the current settings of the database.
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …