RSS from MySQL Database - Non Compliant Characters

[username]

Hi all,

The site I am developing has user submitted content, which occassionally includes characters which are not compliant and cause my rss feed to throw an error. Does anyone have any good ideas as to how to avoid this, or any good resources on scanning the <description> tags which seem to replace these annoying characters with compliant characters. This could be proprietry software.

This does include characters such as " ‘ " which display in HTML but not in XML/RSS feeds.

Thanks in advance.

[eelixduppy]

Have you made any progress with this yet? You might just want to strip them from the submitted content before you post it to RSS by replacing it with an empty string.

[omoutop]

well i can think of 2 possible solutions

a) your xml/rss data be send as utf-8
b) the text is in <![CDATA[some text here]]> format

See if any of these helps

[eeek]

Have you tried running the strings through htmlentities() first?