
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. Dan King Software Developer Canadian Resident Matching Service 613.237.0075 ext. 241 (Toll free) 877.CARMS.42 171 Nepean Street, Suite 300 Ottawa, ON, CAN K2P 0B4 www.carms.ca http://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.
participants (1)
-
Dan King