This content has been marked as final. Show 8 replies
I have Oracle 184.108.40.206.0 with Window XP.
I tried both sql developer as well as using sql command line.
In SQL Developer it is like
And in SQL Command line
but the row not display correctly.
My NLS Setting look like
Edited by: Harry on 23-Jul-2012 05:09
First check your parameters using this query
SELECT * FROM NLS_DATABASE_PARAMETERS;
then check "NLS_CHARACTERSET".
Please first take a backup of your database.
Now forcefully change that parameter to "AL32UTF8".You can ask to your DBA to change this parameter.
Then again check it if it's "AL32UTF8", then you can store characters of any language.
you have this command also.
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
Edited by: S. Wolicki, Oracle on Jul 25, 2012 11:42 PM
This method is unsupported and very dangerous for your database. To migrate to AL32UTF8, use the Database Migration Assistant for Unicode.
No, the steps are incorrect!!! Migrate the database to Unicode using the Database Migration Assistant for Unicode (after upgrading to 220.127.116.11) or create a new one with the AL32UTF8 character set. After you have migrated the database, use VARCHAR2 column for the Book_name column. NVARCHAR2 is not needed and requires additional conversions.
The ALTER DATABASE CHARACTER SET INTERNAL_USE command is, as the name says, for Oracle internal use only and its effects must be well understood before it can be applied.
Patches can only be downloaded from Oracle's Support site - https://support.oracle.com - access to which requires a paid support contract with Oracle
For readers of this thread - pl DO NOT follow the instructions posted above by "Dipak R" - they are unsupported and WILL cause your database to be corrupted BEYOND REPAIR