My Oracle Support Banner

Understanding and Troubleshooting NLS Issues in Web Deployed Oracle Forms (Doc ID 314074.1)

Last updated on DECEMBER 04, 2023

Applies to:

Oracle Forms for OCI - Version 12.2.1.3.0 and later
Oracle Forms - Version 9.0.2 and later
Information in this document applies to any platform.

Purpose

To firstly provide an explanation of how web deployed Oracle Forms handles NLS settings. Secondly to provide troubleshooting hints and tips when unexpected problems / behaviour occurs, for example non-English characters not being saved and/or queried back the database correctly.

Scope

The article is specific to all Forms versions

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Understanding the NLS Basics
 Oracle Forms and the NLS Conversion Process: Inbound to the Database
 Oracle Forms and the NLS Conversion Process: Outbound from the Database
 Setting Up a Basic Oracle Forms NLS Test 
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.