Converting html special characters for localised RSS news

Posted on 2005-03-02
Medium Priority
Last Modified: 2010-04-07
I have developed an asp file (rss.asp) which retrieves records from an sql server 2000 dbase and displays them on home page as hyperlinked (to db) news items. I have a problem with non-unicode characters which I have to convert to unicode on the fly by using html special characters. I tried to insert below function at the top of  rss.asp file but special characters are being rendered as is in browser for eg. Father’s and not Father's. Is there any way to dispaly escape (or special) characters in unicode or any other work around which displays chars correctly? I need to do this as some db titles are in foreign languages.

Function getXML(sourceFile)
dim styleFile
dim source, style
styleFile = Server.MapPath("news.xsl")

Dim xmlhttp
Set xmlhttp = Server.CreateObject("MSXML2.ServerXMLHTTP")
xmlhttp.Open "GET", sourceFile, false

set source = Server.CreateObject("Microsoft.XMLDOM")
source.async = false

set style = Server.CreateObject("Microsoft.XMLDOM")
style.async = false

getXML = source.transformNode(style)
set source = nothing
set style = nothing
End Function
Question by:miamati
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

parths earned 500 total points
ID: 13553239
you can try replacing the special characters by their Unicode values:
' = &#x27;

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question