473,321 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

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 4954
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Robert Zierhofer | last post by:
hi there, it seems as if i can΄t convert the euro and pound sign to their html equivalents. i tried eregi_replace("€", "&euro;", $haystack); eregi_replace("£", "&pound;", $haystack); as...
5
by: Lars | last post by:
Why doesn't the W3C's HTML Validator recognize &euro; and what do I have to do to make my html-file valid?
11
by: MH | last post by:
Thai may have been asked before but I'm new here.... How can I put the Euro symbol, ? using alt0128 in my page and get it validated as HTML 4.01 ? -------------- MH
18
by: gabriel | last post by:
greetings, I am currently working on a website where I need to print the Euro symbol and some "oe" like in "oeuvre". If I choose this : <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0...
2
by: tilmann | last post by:
We are using ASCII-Tablespaces with the Codepage 819 on z/OS. We're now having a problem with the EURO symbol. The data is inserted from a Windows-Client, running Codepage 1252. The Euro symbol is...
5
by: SalamElias | last post by:
I followed instructions in MSDN help articles and wrotethe folowing code in order to display numeric numbers with Euro symbol as follows : ---------------------------- Dim OutString As = "" Dim...
8
by: Max | last post by:
My client has decided to use the Euro for the entire web site. Is there an easy way to get my ASP.NET app to format currency to Euro instead of US-dollar? Right now it's just reading the server...
7
by: kingski | last post by:
Any idea about this ? http://www.developerfusion.co.uk/forums/thread/114379/#114379 "Can any one help me as i am building a shopping cart and it supports multiple currencies but while sending...
7
by: Robertu | last post by:
Hi at all I'ld want inserrt into my emails body the ? euro symbol therefore I wrote the header of my emails like : $headers="From: $mail_from\n\r"; $headers.='X-Mailer: PHP/' ....
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.