Converting Strings for XML Vlaidation

[condoug]

Hi all

I am extrating data from MySQL and this data contains characters such as the following:

£
£
‘

<
&quot;
"
'

So on and so forth..

I am extractong that info and storing it into an XML file bt I need to ensure that all of the above characters (plus any others) are converted into the equivalent unicode character that represents it. So &sup2; is equal to &#178

Is there a way of achieveing this regardless if the character in my string content is a £ or &pound

?

Many Thanks