Home » Developer & Programmer » Forms » How to use SImplified Chinese and traditional chinese (Windows 2003)
How to use SImplified Chinese and traditional chinese [message #430357] Tue, 10 November 2009 03:27 Go to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

Hi,

I have one form in oracle forms10g. In that one text box value i want to put in simplified/traditional chinese and the data should display it in simplified/traditional chinese. I can enter the data in the chinese but in database it is stored as '????'

My nls_parameter_list is as below :
SQL> SELECT * from NLS_DATABASE_PARAMETERS;

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.3.0

waiting for your reply

thanking you.
Re: How to use SImplified Chinese and traditional chinese [message #430485 is a reply to message #430357] Tue, 10 November 2009 11:04 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

NLS_CHARACTERSET WE8MSWIN1252


Try to change database characterset to UTF8

- Babu
Re: How to use SImplified Chinese and traditional chinese [message #430887 is a reply to message #430357] Thu, 12 November 2009 21:31 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
The same question asked here..

http://forums.oracle.com/forums/thread.jspa?messageID=2653360


As this is regarding forms ,you should post this in that Tab...Not in the server administration tab.

sriram Smile

[Updated on: Thu, 12 November 2009 21:34]

Report message to a moderator

Previous Topic: progress bar based on stored procedure
Next Topic: Problem with a form in insert statement
Goto Forum:
  


Current Time: Fri Sep 20 09:40:39 CDT 2024