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 and later
Oracle Forms - Version 9.0.2 and later
Information in this document applies to any platform.


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.


The article is specific to all Forms versions


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
 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 

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