Hello everyone.
I am having problems reading and storing strings in a database. Basically, some characters are being mistakenly replaced with "¿".
For example, when I try to store the following string in the DB 'Centro Cultural TCU presents “Diego e Frida – Um sorriso no meio do caminho"', it is stored 'Centro Cultural TCU presents ¿Diego e Frida ¿ Um sorriso no meio do caminho"', i.e. the characters " " " and " - " have been converted to "¿". Unfortunately, this happens not only with these characters, but also with accents. The DB version I am working with is "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production" and my charset is "WE8ISO8859P1".
My boss said that at the moment it is impossible to make the charset change, since this would impact many applications and this would be chaos.
Has anyone experienced this? Does anyone have any ideas on how to resolve this situation?