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
It is interesting that I have just discovered that the problem only happens with the euro € symbol..
A while ago we had an issue with users entering emojis in the mobile app. By default MySQL can only store 2-byte characters but emojis are 4-byte. This just breaks when storing to DB.
Was discovered in production ...
lesson learnt: hire testers funny enough to use emoticons on their comments :)