1
I’m going through a problem trying to configure my computer to run the application the same way it runs on the server, the characters that are returned from the Oracle database, appear with a ? in place of the special character.
The settings on my computer are:
Windows 7 Enterprise 64 bits
The IIS settings are:
IIS 7.5
The ASP application pages are defined with ANSI encoding and defined in their scope with:
Response.CharSet = "ISO-8859-1"
The previous used on the server, and that consequently I must replicate on my computer is the MSDAORA.
The oracle version is 11g.
Someone’s been through it?
Post the value of
NSL_LANGUAGE
andNLS_CHARACTERSET
for us:SELECT * FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_LANGUAGE');
– Anthony Accioly
Also see if external clients (sqlplus, sqldeveloper, etc.) can return the correct encoding (it may be that the charset is correct but the Inserts have been made with the wrong encoding).
– Anthony Accioly
NLS_LANGUAGE: AMERICAN and NLS_CHARACTERSET: WE8ISO8859P1
– Marco
Another suggestion, the
MSDAORA
is old and full of problems, maybe it is worth trying theOraOLEDB.Oracle
.– Anthony Accioly
Because it is my dear, I changed and brought without problems, the only problem are the calls of Procedure, something is different using this other Provider. I haven’t seen it yet...
– Marco