Windows (1252) characters displayed as ?
102263Jun 2 2004 — edited Jun 3 2004
Hi,
We've recently migrated our 8i databases to 9i and during validation tests we've noticed that some characters are being replaced with ? before they are displayed in the web ui; special characters that were copy and pasted from MS Word.
The text is stored in a CLOB field and we're using OO4O to retrieve the information. The text is then dumped in the body of the HTML page displayed to the user.
We tested versions of the app from different servers and it appears that the one that still uses the 8i client to connect to the 9i backend displays the content properly. The app on the production server that has the 9i client installed and connected to the same backend database, displays the characters incorrectly.
The nls_lang on all server are the same and it matches the database.
So, if all the parameters seems to be the same (code, backend, nls_lang), then is there something different in the clients and the way 8i interprets the CLOB text as opposed to 9i?
Thanks