Is it possible to prevent non-ASCII characters from being entered into self-service fields?
Hi.
I have an ERP 12.2.5 environment. During the original installation of the environment I selected "Character Set = US7ASCII", and as a result both the web tier and the database tier are using "Character Set = US7ASCII".
The system has operating fine for years, but I recently discovered that someone had pasted data from a formatted Word Document into one of the Web-based self-service fields, and this included some non-ASCII data.
The web tier converted the non-ASCII data into something like this ---> ���, and this was saved in the database.
Attempting to query this data from the database results in an error;