Hello there,
We are validating a text entered by the user to be under 4000 characters to avoid Oracle errors. We are using the function "len" to do that.
However, the function is not taking into account special characters (but Oracle does). Is there a way to count the real length of a string including special characters such as return line?
For example01234567890123456789
are 21 characters including one return line in Oracle.
Many thanks!
Discussion posts and replies are publicly visible
Thanks Peter and Mike. Sorry it was my mistake. Len() does consider special characters. The confusion was caused because
0123456789
Is considered as 22 characters by Notepad++ and 21 characters by Appian len().
I believe that Notepad++ uses 2 characters for Return line and Appian one, but there is nothing wrong with that.