grantballantyne
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
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
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
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
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/ CurrentCon trolSet/Co ntrol/Nls/ Codepage
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/
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)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
This needs to be finalized.
If the information that I gave here helps you please Except as Answer.
Or one of the others....
Carrzkiss
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
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
glad that I could help.
Always remember that the characters that you see, is not always what they are.
Have a good one.
Carrzkiss
Always remember that the characters that you see, is not always what they are.
Have a good one.
Carrzkiss
Ton of info here: http://unicode.org/