The pound sign looks fine in the database. To say I'm confused would be an understatement because I've been working with MSSQL and Classic ASP for a long time and have never encountered this.
I'm using the iRite extension to allow the user to input a description, which often includes a pound sign. How do I get iRite to convert the pound sign to the encoded value you've recommended?
I can't use Server.HTMLEncode either because the description includes <p> </p> tags.
I checked the page against W3C validation and, sure enough, there is an error reported related to utf-8:
"Sorry, I am unable to validate this document because on line 302 it contained one or more bytes that I cannot interpret as utf-8 (in other words, the bytes found are not valid values in the specified Character Encoding). Please check both the content of the file and the character encoding indication.
The error was: utf8 "\xA3" does not map to Unicode"
Line 302 is...
<h3><%IF (rsPROPERTY.Fields.Item("SWPCadd").Value) <> "" Then%><%=(rsPROPERTY.Fields.Item("SWPCadd").Value)%>, <%End IF%><%=(rsPROPERTY.Fields.Item("SWPCtown").Value)%>. <%=(rsPROPERTY.Fields.Item("SWPCpostcode").Value)%></h3>
Man I'm confused!
Appreciate the help. Thank you.