Problems with national characters when upgrading from Forms 10g to 11g

Jan 5, 2015 5:13AM

Hi,

We are upgrading a big application from Forms 10G to 11G and have a problem with „national characters“.

Data base is UTF8 (NLS_LANG=AMERICAN_AMERICA.UTF8), 11G (11.2.0.3.0) and we have a lot of characters like ÄÖÜ etc.

While everything worked in 10G, I met such bugs in 11G:

1) Forms field with max.length = 3 and "Data Length Semantics" set to Null gives error when reading from DB a value ‘äöü’.

It works ok if I change “Semantics” to CHAR.

I tried to include “NLS_LENGTH_SEMANTICS =CHAR” into default.env file, but it didn’t help.

2) A procedure inside a Form gives error when I assign value ‘ä’ to variable declared as varchar2(1).

Oracle Forms (MOSC)