Windows characters turning up as ¿
102263May 2 2005 — edited May 2 2005Hi,
My web application (.NET) allows users to save data to a CLOB field. The users will often copy and paste from MS Word to the HTML editor, and when the information is saved and displayed again, special Word characters are converted to ¿.
In the web pages, <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
The character set for the Oracle 9i db is WE8ISO8859P1, and the NLS_LANG parameter on the client is AMERICAN_AMERICA.WE8ISO8859P1.
Just to try it out, I pasted the same text directly into the CLOB field using SQL Navigator and the information was saved properly, more or less. The fancy Word apostrophies were turned into ', and displayed properly by the web application, while words with oe were stored in tact, but with a square box showing up for "oe" in the web interface.