The MSDAORA Provider is returning "?" instead of special characters

Asked

Viewed 401 times

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_LANGUAGEand NLS_CHARACTERSET for us: SELECT * FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_LANGUAGE');

  • 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).

  • NLS_LANGUAGE: AMERICAN and NLS_CHARACTERSET: WE8ISO8859P1

  • Another suggestion, the MSDAORA is old and full of problems, maybe it is worth trying the OraOLEDB.Oracle.

  • 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...

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.