Data in Hindi [message #600557] |
Thu, 07 November 2013 23:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/87624576305926b1e6812638c3471b7b?s=64&d=mm&r=g) |
himanshusinghmbd
Messages: 15 Registered: July 2013 Location: GURGAON
|
Junior Member |
|
|
I want to insert and fetch data in hindi in oracle forms 11g...
when i am taking a field with font krutidev010 its inserting the data in hindi, but when i fetch the data it gives ???? this as a output.
i am working on windows 7 and my database in also 11g.
thanks
|
|
|
|
|
Re: Data in Hindi [message #600576 is a reply to message #600569] |
Fri, 08 November 2013 07:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
shahzad-ul-hasan
Messages: 625 Registered: August 2002
|
Senior Member |
|
|
You can see with this view what are the laguages supported
by your Oracle Server.
1* select * from v$nls_valid_values
SQL> /
PARAMETER VALUE
---------------------------------------------------------------- ------------------
LANGUAGE AMERICAN
LANGUAGE GERMAN
LANGUAGE FRENCH
LANGUAGE CANADIAN FRENCH
LANGUAGE SPANISH
LANGUAGE ITALIAN
LANGUAGE DUTCH
LANGUAGE SWEDISH
LANGUAGE NORWEGIAN
NLS_LANGUAGE parameter or the Oracle supported languages
Change the character set to AL16UTF16
----------------------------------------------
Solution-No 2
To Change the NLS Setting for Oracle Environment / Forms Environment
In (Win95/NT/2000 client ) by using the blow details .
Title : NLS Setting for Oracle Environment:
--------------------------------------------------------------
You can change database character set by doing the following steps.
Login to oracle Database server as sys privilege. If Sys Is Primary User otherwise Login to oracle Database server as system privilege.
Step1 : connect sys@Database_Name as sysdba;
Step2 : shutdown immediate;
Step3 : startup mount;
Step4 : alter system enable restricted session;
Step5 : alter system set job_queue_processes=0;
Step6 : alter system set aq_tm_processes=0;
Step7 : alter database open;
Step8 : alter database Database_Name character set AR8MSWIN1256;
Step9 : alter database Database_Name national character set AR8MSWIN1256;
Step10 : shutdown immediate;
Step11 : startup;
Title : Check Current Database Character:
--------------------------------------------------------------
Step1: Select * from v$nls_parameters;
Or
Step2: select * from nls_database_parameters;
Title : NLS Setting for Forms Environment In (Win95/NT/2000 client ):
-----------------------------------------------------------------------------------------------------
Step1 : Run regedit, Registry window will appears
Step2 : Select HKEY_LOCAL_MACHINE
Step3 : Select SOFTWARE
Step4 : Select ORACLE
Step5 : Select NLS_LANG .(Its Available In right Side)
Step6 : Double Click NLS_LANG and then enter the value as
AMERICAN_AMERICA.AR8MSWIN1256
|
|
|