I emailed this problem a few weeks ago. It relates to
special characters being saved in the database from the application. Whenever
it saves special characters, such as é and so on somewhere along the line it is
converted to a question mark.
I have done extensive investigation to fix this
problem but have fallen short on fixing it for OTRS.
Attempts to narrow down where the conversion from an ‘é’
to a ‘?’ has given me the thought that it is happening somewhere
within the OTRS system or on an agents computer or web browser. This is due to
being able to successfully insert a ‘é’ into the database using
sqlplus and successfully being able to select that data from the database using
sqlplus.
I also wrote a perl test script that would insert a
special character into the database and then read and display the results. It
was able to do this successfully.
As far as I can tell the data should be in iso-8859-1
character set all throughout the process from being typed in at the browser, to
being placed in a perl variable, inserting it into the database and then
selecting it from the database.
If anyone has any ideas on what I can do to solve my
issue or have any questions that can clarify my problem please send me an
email.
Thank you for the help.
Canadian Resident Matching Service
613.237.0075 ext. 241
(Toll free) 877.CARMS.42
www.carms.ca
------------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the sole use of the
intended recipients and may contain confidential and or privileged
information. If you are not the intended recipient or this information
has been forwarded in error, please contact the sender by reply e-mail and
destroy copies of the original message. Ce message (incluant toute pièce jointe) s'adresse uniquement
au(x) destinataire(s) prévu(s) ou à une personne autorisée à le recevoir en son
(leur) nom. Il pourrait contenir des renseignements confidentiels ou protégés.
Si vous l'avez reçu par erreur, nous vous prions d'en informer l'auteur
dans les meilleurs délais, de ne pas divulguer son contenu et de le supprimer
de votre système. Merci.