Avatar of grantballantyne
grantballantyneFlag for United Kingdom of Great Britain and Northern Ireland asked on

displays  instead of £

Dear Experts

We are using SQL 2005 and ASP.  Our webpages are displaying a  Â sign instead of a £ sign.

Can anyone advise how to resolve this?

Thanks for any help
ASPMicrosoft SQL ServerMicrosoft Development

Avatar of undefined
Last Comment
Wayne Barron

8/22/2022 - Mon
psasik

Simply changing your font may fix the issue but you should also look into the encoding that you're using. You might be using an encoding that does not support the £ symbol.

Ton of info here: http://unicode.org/

Wayne Barron

In your page you want it to show:   £
That is the HTML code for the character you have there.
All you need to know is right here
http://www.ascii.cl/htmlcodes.htm

Good Luck
Carrzkiss
andy232

It is a character set transalation error.

Do a sp_help <table name> on the table name with that has £ and look for the collation on your column.   Your web server and pages need to be running that same character set on the codepage registry key
HKEY_LOCAL_MACHINE/System/CurrentControlSet/Control/Nls/Codepage
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
psasik

Grant,

this is perhaps a better link for you:

http://www.fileformat.info/info/unicode/char/00a3/index.htm

(all about the sterling pound character in the unicode set)
ASKER CERTIFIED SOLUTION
Wayne Barron

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Wayne Barron

grantballantyne,
This needs to be finalized.
If the information that I gave here helps you please Except as Answer.
Or one of the others....

Carrzkiss
Wayne Barron

grantballantyne
Please come in and finalize this one.
Tomorrow will make a month that you opened this question.
We all made our comments on the same day.
Please except one of more of the above comments as your answer.

And considering that I provided the HTML code for fixing your issue.
It should be easy to figure out and fix.

Please finalize
Carrzkiss
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Wayne Barron

glad that I could help.
Always remember that the characters that you see, is not always what they are.

Have a good one.
Carrzkiss