0

Working with an .asp application that connects and displays data cleanly. Problem occurs with Greek and Polish characters. They render with 'upside down question mark'. Running on IIS6 / Win2003. I think Oracle 10.2.0.4 is installed.

It seems the code is using Response.CodePage = 65001 and Response.CharSet = UTF-8, e.g.:

<%
    Response.Buffer = false
    'Response.flush

    ' set up UTF-8 character set
    Response.ContentType = "text/html"  
        Response.AddHeader "Content-Type", "text/html;charset=UTF-8"  
        Response.CodePage = 65001  
        Response.CharSet = "UTF-8"  
%>

So far I've tried changing from:

'sConnectString = "PROVIDER=MSDAORA;" & _

to:

sConnectString = "Provider=OraOLEDB.Oracle;" & _

Using this OraOLEDB.Oracle Provider string allows Greek and Polish characters to display properly. (changing the provider resolved)

Does this change from an MS Oracle driver (.dll?) to an Oracle driver (.dll?) Why does this work? How do I check what driver versions I have installed?

Any additional references or caveats you would recommend? So far, reviewed:

Using ASP to Internationalize Your Web Pages on Windows 2000

Oracle forums

Stackoverflow thread

Community
  • 1
  • 1
RussMcGrindle
  • 103
  • 4

1 Answers1

0

In what character set is your Oracle database?

The Microsoft Oracle Provider MSDAORA is very old, it was never updated since Oracle 7.0, it does not support Unicode. The OraOLEDB.Oracle is much newer. That explains why it works with the Oracle driver.

Jeff
  • 736
  • 5
  • 14
  • @user569090 - ah, thanks for that clarification on MSDAORA and age. If I follow your question(?) the db charset is UTF8. So far, so good.... – RussMcGrindle Apr 06 '11 at 18:10