Oracle Tips by Burleson

Oracle 10g Overwriting Locale in OGS

OGS also provides a method for the application to overwrite the locale preference information stored in either the LDAP server or in the user profile table in the database. This will also reset the current locale information stored inside the local cookie for the current session.

This operation is ignored when the user input locale or the HTTP Locale preference is used because these locale sources are read-only.

Character Set Handling in OGS

Oracle Database 10g OGS supports these scenarios for setting the character sets of the application HTML pages:

• A single local character set is dedicated to the application. Single local character sets are appropriate only for a monolingual internet application.
   

• Use the native character set for each language. For example, English contents are represented in ISO-8859-1 and Japanese contents are represented in Shift_JIS. This would be appropriate for multilingual internet applications that use the default character set mapping for each locale.
   

• Use Unicode UTF-8 for all contents regardless of the language. This is appropriate for multilingual applications that use Unicode for deployment.
   

• OGS does not support the scenario where the incoming character set is different from that of the outgoing character set.

The character set information is specified in the OGS application configuration file. This configuration information is used by ServletRequestWrapper and ServletResponseWrapper classes, which set the proper character set for the request object. It is also used by the ContentType class for output when instantiated.

When the page-charset is set to auto-charset, then the character set of the incoming content is determined to be the default character set of the current user locale. The default character set is derived from the locale-to-character-set mapping table, specified in the application configuration file. When the character set mapping table in the application configuration file is not available, then the locale is based on the table that maps the default locale name to the IANA character in OGS. The default character mappings are derived from the OraLocaleInfo class.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm