Hi,
I am having a problem with the character counter of an item defined as text area.
I have the following validation on page submit.
plsql expression
nvl(length(:P1_DESCRIPTION),0) <= 2000
After my copy/paste of a text, the counter shows 2000 of 2000. But when submitting the page the validation fails, so it wouldn't allow me to go ahead and save.
But when I do this computation after submit on my item
return replace(:P1_DESCRIPTION, chr(13) || chr(10), chr(10));
the vaidation doesn't fail.
The description field is declared VARCHAR2(2000 CHAR) in the database, so it would not allow me to save more than 2000 char
But I can not save my text without linefeed and carriage return in my Database.
Is there any problem with Apex character counter?
The bug first occurred in Apex 4.2 but in Apex 5 it seems to be fixed. But we are still using the Apex 4.2 is there a way to solce this problem or a workaround?
I think some one must have encounter this.
Thanks for any input