Hi all,
We are having problems when a user enters special characters ($,<,> etc) in an interface. The data is stored in the DB and later on reloaded in the form incorrectly.
I have checked in our Oracle DB that value for NLS_CHARACTERSET is WE8ISO8859P1 and the value for NLS_NCHAR_CHARACTERSET is AL16UTF16
Does that mean that our DB is not configured to handle special characters? Should we ask our DBA to change the configuration in order to support the special characters?
Alternatively, is there any way to solve the problem from the code? I have seen in similar questions that a clean or substitute function could help. I think the best option is to write a funcion with multiple substitutes to store < instead of "<" and so on.
Thanks a lot!
Discussion posts and replies are publicly visible
REGEX would probably work, but you could also use out-of-the-box Appian functions.
The stripwith() function will remove any characters you define as invalid. So if you wanted to specifically remove the some symbols, you can use stripwith() like this:
stripwith(
[Text Here],
"@*^<>+)/("
)
Thanks, removing the symbols is not desired because the users want to see them, so I think is better to substitute them.
However I would prefer to do the configuration at the DB level, as doing it in the code will require to change multiple places.