asked on

£ (pound) shows incorrect in asp

I have a drop down select box in a .asp web page
I have a table in access.mdb with a currency table having two fields only
ID and currency
The currency field is a text field
If I enter a £ sign in the table, when the items shows in the drop down select box, the £ shows as A£ and the A has an accent over the top of the letter.
Is there a way I can prevent this please?

Just a point the $ sign shows correct
Thanks John

Ashish Patel

Top of your asp page write this
<%
Response.Charset = "windows-1250"
Response.ContentType = "text/html"
%>

johnhardy

ASKER

Thanks
It now shows as

UK-ÂA

Ashish Patel

Okay so your problem has a solution, convert the Charset to Unicode and it should work fine. Find in google to uncode charset.

Ashish Patel

Try this
Response.Charset = "ISO-8859-1"

Ashish Patel

Cheers this works good for me now.
<%
Response.Charset = "ISO-8859-1"
Response.ContentType = "text/html"
%>

johnhardy

ASKER

Thanks
With Response.Charset = "ISO-8859-1" it shows as UK-Â£

Ashish Patel

Okay buddy, now there is some extra charater in your table value as you can see there is a £ sign at the end. So just filter the value and re - type it in the table value if you can. Let me know.

ASKER CERTIFIED SOLUTION

Ashish Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

johnhardy

ASKER

Thanks asvforce looks like "UTF-8" has done the trick.
Very kind of you th help
Regards
John

Ashish Patel

My Pleasure John

johnhardy

ASKER

Heres an interesting thing
I just went into my questions knowledge base to see if I could find this question by searching with £

However the search box on submit turns the £ sign into Â£