473,513 Members | 2,366 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

May 23 '06 #1
11 2371
Roy wrote:
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?
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.
May 23 '06 #2
Roy
Both servers use IIS, what should I check on the server to find out the cause?

"Dave Anderson" wrote:
Roy wrote:
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?
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

May 23 '06 #3

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:7E**********************************@microsof t.com...
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.

May 23 '06 #4
Roy
Both servers show 1252 as Session.CodePage.
Any other ideas on what difference I should check?

"Anthony Jones" wrote:

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:7E**********************************@microsof t.com...
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.


Jun 5 '06 #5

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:C7**********************************@microsof t.com...
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?

"Anthony Jones" wrote:

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:7E**********************************@microsof t.com...
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.


Jun 6 '06 #6
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" wrote:

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:C7**********************************@microsof t.com...
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?

"Anthony Jones" wrote:

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:7E**********************************@microsof t.com...
> 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.



Jun 8 '06 #7

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:37**********************************@microsof t.com...
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.

Thank so much for your great suggestion in the puzzle.

Roy.

"Anthony Jones" wrote:

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:C7**********************************@microsof t.com...
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?

"Anthony Jones" wrote:

>
> "Roy" <Ro*@discussions.microsoft.com> wrote in message
> news:7E**********************************@microsof t.com...
> > 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.
>
>
>
>
>
>


Jun 9 '06 #8
See Below ( no top posting please)
On Fri, 9 Jun 2006 12:48:32 +0100, "Anthony Jones" <An*@yadayadayada.com> wrote:

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:37**********************************@microso ft.com...
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.

Thank so much for your great suggestion in the puzzle.

Roy.

"Anthony Jones" wrote:
>
> "Roy" <Ro*@discussions.microsoft.com> wrote in message
> news:C7**********************************@microsof t.com...
> > 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 textfile > 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 comingthrough. > if ® then something is happening to it on its way to the browser but ifit'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?
>
>
> > "Anthony Jones" wrote:
> >
> > >
> > > "Roy" <Ro*@discussions.microsoft.com> wrote in message
> > > news:7E**********************************@microsof t.com...
> > > > Does anybody have any idea why 2 identical classic asp pages,hitting > the
> > > > same Oracle schema, but deployed on 2 different servers willrender > 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 accordingthe > > > current Session.CodePage setting. (In IIS 6 there is aResponse.CodePage > as
> > > well).
> > >
> > > You will probably find that Session.CodePage on server A isdifferent > than
> > > on server B at the point when the value is written.
> > >
> > > The default Session.CodePage is defined by the system code pagehowever > any
> > > page that modifies this value can affect the output of other pages
> during
> > > that session.
> > >
> > >
> > >
> > >
> > >
> > >
>
>
>


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.
Jun 9 '06 #9
Roy


"Turkbear" wrote:
See Below ( no top posting please)
On Fri, 9 Jun 2006 12:48:32 +0100, "Anthony Jones" <An*@yadayadayada.com> wrote:

"Roy" <Ro*@discussions.microsoft.com> wrote in message
news:37**********************************@microso ft.com...
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.

Thank so much for your great suggestion in the puzzle.

Roy.

"Anthony Jones" wrote:

>
> "Roy" <Ro*@discussions.microsoft.com> wrote in message
> news:C7**********************************@microsof t.com...
> > 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?
>
>
> > "Anthony Jones" wrote:
> >
> > >
> > > "Roy" <Ro*@discussions.microsoft.com> wrote in message
> > > news:7E**********************************@microsof t.com...
> > > > 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.
> > >
> > >
> > >
> > >
> > >
> > >
>
>
>


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?

Jun 9 '06 #10
Turkbear wrote:
See Below ( no top posting please)

Please do some snipping ...
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jun 9 '06 #11
On Fri, 9 Jun 2006 10:43:02 -0700, Roy <Ro*@discussions.microsoft.com> wrote:


"Turkbear" wrote:

.Snipped
>


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?


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)
Jun 9 '06 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3083
by: Mohammed Mazid | last post by:
Can anyone please help me on how to move to the next and previous question? Here is a snippet of my code: Private Sub cmdNext_Click() End Sub Private Sub cmdPrevious_Click() showrecord
3
4997
by: Stevey | last post by:
I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>
7
2630
by: nospam | last post by:
Ok, 3rd or is it the 4th time I have asked this question on Partial Types, so, since it seems to me that Partial Types is still in the design or development stages at Microsoft, I am going to ask...
3
3060
by: Ekqvist Marko | last post by:
Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table...
10
3391
by: glenn | last post by:
I am use to programming in php and the way session and post vars are past from fields on one page through to the post page automatically where I can get to their values easily to write to a...
10
3683
by: Rider | last post by:
Hi, simple(?) question about asp.net configuration.. I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm first start application the follow message shown. ========= Server...
53
4022
by: Jeff | last post by:
In the function below, can size ever be 0 (zero)? char *clc_strdup(const char * CLC_RESTRICT s) { size_t size; char *p; clc_assert_not_null(clc_strdup, s); size = strlen(s) + 1;
56
4696
by: spibou | last post by:
In the statement "a *= expression" is expression assumed to be parenthesized ? For example if I write "a *= b+c" is this the same as "a = a * (b+c)" or "a = a * b+c" ?
2
4253
by: Allan Ebdrup | last post by:
Hi, I'm trying to render a Matrix question in my ASP.Net 2.0 page, A matrix question is a question where you have several options that can all be rated according to several possible ratings (from...
3
2540
by: Zhang Weiwu | last post by:
Hello! I wrote this: ..required-question p:after { content: "*"; } Corresponding HTML: <div class="required-question"><p>Question Text</p><input /></div> <div...
0
7267
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7391
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7553
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7120
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
3247
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3235
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1609
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
809
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
466
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.