469,592 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

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
Jan 5 '07 #1
4 4767
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.
Jan 5 '07 #2

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

Jan 5 '07 #3
Kim
Changing the codepage seems to work. Thanks a million times for your
answers. Kim.
Jan 6 '07 #4

"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
Jan 6 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Robert Zierhofer | last post: by
5 posts views Thread by Lars | last post: by
11 posts views Thread by MH | last post: by
18 posts views Thread by gabriel | last post: by
2 posts views Thread by tilmann | last post: by
5 posts views Thread by SalamElias | last post: by
8 posts views Thread by Max | last post: by
7 posts views Thread by kingski | last post: by
7 posts views Thread by Robertu | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.