Euro ( ? ) turns up "?"

[Kim]

Inserting a record through sql (asp, msaccess textfield), inserting the euro
sign "?" shows up like a questionmark "?" in the output.

I have <%@ LANGUAGE="VBSCRIPT" CodePage=28591 LCID=2077 %at the top of the
page where the insert statement is but still the euro sign is inserted like
something else (by looking at the data in the access database the euro sign
looks like a little square "€")

Whats wrong? Kim

[Dave Anderson]

Kim wrote:

Inserting a record through sql (asp, msaccess textfield), inserting
the euro sign "?" shows up like a questionmark "?" in the output.

I have <%@ LANGUAGE="VBSCRIPT" CodePage=28591 LCID=2077 %at the top
of the page where the insert statement is but still the euro sign is
inserted like something else (by looking at the data in the access
database the euro sign looks like a little square "€")

Do you mean it is not getting into MS Access as a €, or when it is rendered
by the browser?

If the latter, you should use Server.HTMLEncode():

Response.Write(Server.HTMLEncode("€")) --€

The browser correctly renders it and submits it as € in form elements.


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

[Anthony Jones]

"Kim" <ki*@hgnmail.comwrote in message
news:eZ**************@TK2MSFTNGP04.phx.gbl...

Inserting a record through sql (asp, msaccess textfield), inserting the

euro

sign "?" shows up like a questionmark "?" in the output.

I have <%@ LANGUAGE="VBSCRIPT" CodePage=28591 LCID=2077 %at the top of

the

page where the insert statement is but still the euro sign is inserted

like

something else (by looking at the data in the access database the euro

sign

looks like a little square "€")

Whats wrong? Kim

Strictly speaking the Euro symbol is not in the ISO-8859-1 codepage. (Which
is why in Dave's example Server.HTMLEncode uses a unicode entity to
represent it).

Use CodePage=1252 and ensure that the source page (where the form is
rendered) includes the code:-

Response.Codepage = "Windows-1252"

[Kim]

Changing the codepage seems to work. Thanks a million times for your
answers. Kim.

[Anthony Jones]

"Anthony Jones" <An*@yadayadayada.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

>
"Kim" <ki*@hgnmail.comwrote in message
news:eZ**************@TK2MSFTNGP04.phx.gbl...

Inserting a record through sql (asp, msaccess textfield), inserting the

euro

sign "?" shows up like a questionmark "?" in the output.

I have <%@ LANGUAGE="VBSCRIPT" CodePage=28591 LCID=2077 %at the top of

the

page where the insert statement is but still the euro sign is inserted

like

something else (by looking at the data in the access database the euro

sign

looks like a little square "€")

Whats wrong? Kim

Strictly speaking the Euro symbol is not in the ISO-8859-1 codepage.

(Which

is why in Dave's example Server.HTMLEncode uses a unicode entity to
represent it).

Use CodePage=1252 and ensure that the source page (where the form is
rendered) includes the code:-

Response.Codepage = "Windows-1252"

Oops that should be Response.CharSet