I have Oracle 11g.
In my database one table look like.
font -- Table Name
ID -- number Primary Key,
when i fire insert command on that insert into font values (font_seq.nextval,'સ્વાગત');commit;
the insert charter is gujarati and insert data correctly.
when i check using SQL > select BOOK_NAME From font;
■■■■■■ How can i display my guajrati data from database ?
How to use NLS_LANG in Oracle?
Help me out
Pl identify exact database and OS versions, along with which tool you are using to execute the insert and select commands - use SQL*Developer to execute the select command and verify if it displays the correct data.
I have Oracle 220.127.116.11.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 18.104.22.168) 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