® vs. ? question

[Roy]

Does anybody have any idea why 2 identical classic asp pages, hitting the
same Oracle schema, but deployed on 2 different servers will render the
registered trade mark differently?

Example:

PROTONIX®

get displayed when calling the page deployed on server A, while

PROTONIX?

get displayed from calling the same code deployed on server B (still hitting
the same Oracle schema)

The Oracle field is defined is VARCHAR2

Both pages are being called from the same browser instance on workstation C.

 

[Dave Anderson]

Does anybody have any idea why 2 identical classic asp pages, hitting
the same Oracle schema, but deployed on 2 different servers will
render the registered trade mark differently?

Does "same Oracle schema" mean "same Oracle instance"? Could the problem not
be the web server?

 

[Roy]

Both servers use IIS, what should I check on the server to find out the cause?

 

[Anthony Jones]

Does anybody have any idea why 2 identical classic asp pages, hitting the
same Oracle schema, but deployed on 2 different servers will render the
registered trade mark differently?

Example:

PROTONIX®

get displayed when calling the page deployed on server A, while

PROTONIX?

get displayed from calling the same code deployed on server B (still hitting
the same Oracle schema)

The Oracle field is defined is VARCHAR2

Both pages are being called from the same browser instance on workstation C.

Ultimately you will be outputing your text using a form of Response.Write.

It's at this point that a unicode string in ASP is encoded according the
current Session.CodePage setting. (In IIS 6 there is a Response.CodePage as
well).

You will probably find that Session.CodePage on server A is different than
on server B at the point when the value is written.

The default Session.CodePage is defined by the system code page however any
page that modifies this value can affect the output of other pages during
that session.

 

[Roy]

Both servers show 1252 as Session.CodePage.
Any other ideas on what difference I should check?

 

[Anthony Jones]

Both servers show 1252 as Session.CodePage.
Any other ideas on what difference I should check?

One diagnostic you might try is to have the code create a unicode text file
using the Scripting.FileSystemObject and write the content of the field
value to the file. Make sure you use Unicode.

Open the file in Notepad to see what character is actually coming through.
if ® then something is happening to it on its way to the browser but if it's
? then the character isn't coming through to ADO correctly.

Does anything else happen to the value before you Response.Write it?
Does it ultimately end up being sent to the client via Response.Write or
some other method?

 

[Roy]

I used Scripting.FileSystemObject to save a text file in unicode and the
character came as ?. So this is an ADO issue.
What should I check on the ADO side ?

Thank so much for your great suggestion in the puzzle.

Roy.

 

[Anthony Jones]

I used Scripting.FileSystemObject to save a text file in unicode and the
character came as ?. So this is an ADO issue.
What should I check on the ADO side ?

I'm afraid I know very little about Oracle I suggest you take this problem
to an Oracle forum where those familiar with it will be able to help you.

 

[Turkbear]

See Below ( no top posting please)

I'm afraid I know very little about Oracle I suggest you take this problem
to an Oracle forum where those familiar with it will be able to help you.

The NLS_ parameters ( which control the character set used) is controlled by the registry setings of the Oracle client
machine ( in your case the web server using the asp code) ; as long as ANY NLS_ parameter is set in the client regisrty,
ALL NLS_ parameters will use the registry setings or revert to default..

So, when running the same code from2 different servers results in different resuts, it is likely to mean that the values
in the registry section for Oracle differ.

 

[Bob Barrows [MVP]]

See Below ( no top posting please)

Please do some snipping ...

 

[Roy]

See Below ( no top posting please)


The NLS_ parameters ( which control the character set used) is controlled by the registry setings of the Oracle client
machine ( in your case the web server using the asp code) ; as long as ANY NLS_ parameter is set in the client regisrty,
ALL NLS_ parameters will use the registry setings or revert to default..

So, when running the same code from2 different servers results in different resuts, it is likely to mean that the values
in the registry section for Oracle differ.

How do I access these registry settings? Is that through Oracle client gui,
or the windows registry editor?

 

[Turkbear]

:

.Snipped
How do I access these registry settings? Is that through Oracle client gui,
or the windows registry editor?

The windows registry on each web server ( be careful, ask your DBA for help if unsure what to remove)..

There should be an section in HKLM_Software_Oracle where NLS_ parametrrs are listed..Be sure they are the same ( or
delete them entirely, then Oracle's system setings will apply)