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

Last updated on AUGUST 12, 2019

Applies to:

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:

• Oracle 9iAS Rel 1 Forms Services (Forms 6i (6.0.8))
• Oracle 9iAS Rel 2 Forms Services (Forms 9i (9.0.2))
• Oracle 9iDS Rel 2 (Forms 9i (9.0.2))
• Oracle Application Server 10g (9.0.4) Forms Services (Forms 10g (9.0.4))
• Oracle Developer Suite 10g (9.0.4) (Forms 10g (9.0.4))
• Oracle Application Server 10g (10.1.2) Forms Services (Forms 10g (10.1.2))
• Oracle Developer Suite 10g (10.1.2) (Forms 10g (10.1.2))
  
• Oracle Fusion Middleware 11gR1 (11.1.1) Forms Services (Forms 11g (11.1.1))
  

Target Audience: Support Engineers, Consultants, System Administrators, DBAs and Developers

Details

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