Coldfusion – How to get rid of the strange characters in my RSS?

cfif news.RecordCount GT 0>






 
 
 #Application.siteRoot#
 Welcome to the News RSS Feed
 < lastBuildDate>Wed, 19 Nov 2008 09:05:00 GMT
 en-uk
 

 
 
 
 news.headline = replace(news.headline, "<", "<", "ALL");
 news.body = replace(news.body, "<", "<", "ALL");
 news.date = dateformat(news. date, "ddd, dd mmm yyyy");
 news.time = timeformat(news.time, "HH:mm:ss") & "GMT"; 
  
 
 
 #Application.siteRoot#news/index.cfm?id=#news.id#
 #Application.siteRoot#news/index.cfm?id=#news.id#
 #news.date# #news.time#
 #news.body#
 
 
 

 

 
 #Application.siteRoot#news/index.cfm?id=#XMLFormat(news.id)#
 #Application .siteRoot#news/index.cfm?id=#XMLFormat(news.id)#
 #XMLFormat(news.date)# #XMLFormat(news.time)# 
 #XMLFormat(news.body)#

I created a utf8-encoded RSS feed, which provides news data extracted from the database. I have set all aspects of my database to utf8, and by pasting it into Notepad and saving it as utf8 To save the text I put into the database as utf8. Therefore, when the RSS feed is presented to the browser, everything should be encoded in utf8, but I still get the strange question mark character of the pound sign: (

< p>This is my RSS feed code (CFML):

< cfinvoke component="com.news" method="getAll" dsn="#Request.App.dsn#" returnvariable="news" />


cfif news.RecordC ount GT 0>






 
 
 #Application .siteRoot#
 Welcome to the News RSS Feed
 Wed, 19 Nov 2008 09:05:00 GMT
 en-uk
  

 
 
 
 news.headline = replace( news.headline, "<", "<", "ALL");
 news.body = replace(news.body, "<", "<", "ALL");
 news.date = dateformat(news.date, "ddd, dd mmm yyyy");
 news.time = timeformat(news.time, "HH:mm:ss") & "GMT"; 
  
 
 
 #Application.siteRoot#news/index.cfm?id=#news.id#
 #Application.siteRoot#news/index.cfm ?id=#news.id#
 #news.date# #news.time#
 #news.body#< br /> 
 
 



 

Does anyone have any suggestions? I did a lot of research, but couldn’t find any answer: (

Thanks in advance,

Chromis

Get rid of the escape code and use XMLFormat instead:

 
 #Application.siteRoot#news/index.cfm?id=#XMLFormat(news.id)#
 #Application.siteRoot#news/index.cfm?id=# XMLFormat(news.id)#
 #XMLFormat(news.date)# #XMLFormat(news.time)#
 #XMLFormat(news. body)#

View XMLFormat livedoc page.