This content has been marked as final. Show 1 reply
I have a column VARCHAR2(100) and textarea with counter is used to collect data. Maximum width for textarea is 100.
When I try to save 99 alphanumeric characters and 1 newline I get "ORA-01461: can bind a LONG value only for insert into a LONG column" error.
One newline is counted as 1 character by textarea, when in fact 2 characters are stored: carriage return and line feed.
Apex version is 3.1.2, but the same problem exists on 4.2.1 (apex.oracle.com).
Hi. Like they say on TV sometimes: "Is there a question in there?"
I gather you don't want it to work this way. Okay? What are you trying to achieve? What do you want to happen?
I guess if there will always be an EOL, then make the field 101 long. Or do you get the error no matter what length you make the field? I can suggest that you not allow newlines or you strip them off after they are entered. Would either of those ideas work?