Oracle Forms 10g FRM-40831 error
Hi
I'm having trouble with "FRM-40831 Truncation occurred, value too long for field" error.
The error started to appear once test environment Oracle App Server and OS (windows) NLS was set to AMERICAN_AMERICA.AL32UTF8.
In production where the field does not give error it is set to ESTONIAN_ESTONIA.BLT8MSWIN1257.
Both underlying databases are AMERICAN_AMERICA.AL32UTF8.
The field length in question shows max length 30 chars and data length semantics is set to null (in both environments).
The length of the data from the database that goes into the text field is 33 chars.
The data itself has some estonian specific characters like "ö" and couple of "/" and spaces.