This discussion is archived
3 Replies Latest reply: Nov 7, 2013 1:20 AM by T. Morton RSS

Forms 10g + UTF8 - Item displays #### when it's content are too long

T. Morton Newbie
Currently Being Moderated



I'm facing a strange behaviour with Forms 10g and NLS_LANG=UTF8.

DB 11G withcharset in AL32UTF8 on Linux

Forms 10G on Linux


We are currently upgrading our application form DB 10G to DB 11G + UTF8.

After coping DB data from 10G to 11G, we changed columns sementics from BYTE to CHAR in DB 11G.

Migration worked fine.


Now we try to connect our application in Forms 10G to the new DB 11G + UTF8.

First we faced the error ORA-01461"can bind a long value only for insert into a long column".

To solve this error, we specified the NLS_LANG=american_america.utf8 in default.env.

This problem is fixed now.


We have specified the following parameters while compiling:






The application runs fine except for some ITEMs which display #### when their content is too long.

For exemple with an ITEM Varchar2(5) length_semantics=NULL (So the compiler uses the NLS_LENGTH_SEMANTICS specified during compilation).

-- When I fill it with 'xxxxx' it works fine.

-- When I fill it with 'xxxxé' it displays '#####'. The ITEM behave like in Excell when cell data cannot be displayed in a whole.


Any idea on how I can avoid this behaviour ?


Thanks in advance.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points