| Multilingual Form [message #492996] |
Fri, 04 February 2011 03:44  |
ali_sakar
Messages: 22
Registered: February 2009
Location: Mumbai
|
Junior Member |
|
|
Hi all,
My requirement is to create Multilingual form. Its very urgent. In fact if i want to make it work in 2 languages. English and Chinese.
Can anyone help me with the steps i need to follow.
Thanking in advance,
Ali
|
|
|
|
| Re: Multilingual Form [message #493142 is a reply to message #492996] |
Sat, 05 February 2011 08:23  |
owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT
|
Senior Member |
|
|
hi here is link for u
http://otn.oracle.com/tech/globalization/, and see the Oracle
iSQL*Plus supports multiple languages through the Unicode UTF-8 character encoding in the web browser you use for the iSQL*Plus session, and through the AL32UTF8 encoding (Oracle's implementation of Unicode) in the iSQL*Plus Application Server serving the session.
If your Oracle Database also uses AL32UTF8, then there is a one-for-one correspondence between the character sets in the database and in iSQL*Plus. Otherwise some character mapping may occur.
Web Browser
No changes are necessary to have multilingual support in your iSQL*Plus web browser. However, your browser must support UTF-8 character encoding. Most current web browsers support UTF-8.
The character encoding in the iSQL*Plus browser is set to UTF-8 by the charset attribute in the header of HTML pages returned from the iSQL*Plus Application Server.
Application Server
The language and territory values of the NLS_LANG environment variable in effect when the iSQL*Plus Application Server starts specifies behavior for the iSQL*Plus Application Server. The character set value is ignored.
The language and territory values set for an application server are used for all iSQL*Plus sessions run from that application server. However, you can use an ALTER SESSION command to change the language and territory used for the duration of the current session. For example, to use Chinese language and conventions in your current session, enter
SIMPLY FOR CHINESE LANGUAGE
-------------------------------------------------
ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
ALTER SESSION SET NLS_TERRITORY='CHINA';
--------------------------------------------------
SELECT * FROM NLS_SESSION_PARAMETERS;
NLS_LANG has the syntax:
NLS_LANG = language_territory.charset
---------------------------------------------------
NLS_LANG=JAPANESE_JAPAN.WE8DEC
However, Japanese could be supported with the Unicode character set. For example:
NLS_LANG=JAPANESE_JAPAN.UTF8
SELECT * FROM NLS_SESSION_PARAMETERS;
Example 12-1 Configuring Japanese Support in SQL*Plus on Windows
1. Ensure you have exited your current SQL*Plus session.
2. Open System from Start > Settings > Control Panel.
3. Click the Advanced tab and select Environment Variables.
4. Create a new environment variable, NLS_LANG, with a value of Japanese_Japan.UTF8.
5. You may need to restart Windows for this setting to take effect.
Example 12-2 Configuring Japanese Support in SQL*Plus on UNIX
1. Ensure you have exited your current SQL*Plus session.
2. Set the NLS_LANG variable using either set or setenv depending on the UNIX shell you are using. For example, in csh, you would enter:
3. setenv NLS_LANG Japanese_Japan.UTF8
Example 12-3 Configuring Japanese Support in Oracle Database
To store data in the Japanese character set using UTF-8 character encoding, ensure that the Oracle database has been created with the UTF8 character set. See your Oracle Database Installation Guide for information about creating your database in a character set other than US7ASCII.
thanks
[Updated on: Sat, 05 February 2011 08:32] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
