[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

£ (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
0
johnhardy
Asked:
johnhardy
  • 7
  • 4
1 Solution
 
Ashish PatelCommented:
Top of your asp page write this
<%
Response.Charset = "windows-1250"
Response.ContentType = "text/html"
%>
0
 
johnhardyAuthor Commented:
Thanks
It now shows as

UK-ÂA
0
 
Ashish PatelCommented:
Okay so your problem has a solution, convert the Charset to Unicode and it should work fine. Find in google to uncode charset.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Ashish PatelCommented:
Try this
Response.Charset = "ISO-8859-1"
0
 
Ashish PatelCommented:
Cheers this works good for me now.
<%
Response.Charset = "ISO-8859-1"
Response.ContentType = "text/html"
%>
0
 
johnhardyAuthor Commented:
Thanks
With Response.Charset = "ISO-8859-1" it shows as UK-£
0
 
Ashish PatelCommented:
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.
0
 
Ashish PatelCommented:
Or try setting charset to "UTF-8" which is used in this experts-exchange site where the pound sign is displayed properly. You can see the source of the page.
0
 
johnhardyAuthor Commented:
Thanks asvforce looks like "UTF-8" has done the trick.
Very kind of you th help
Regards
John
0
 
Ashish PatelCommented:
My Pleasure John
0
 
johnhardyAuthor Commented:
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 £
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now