XMLElement and special characters

Hi,


I have an SQL statement that builds an XML document using XMLELEMENT as follows;


XMLELEMENT(NAME "DescriptionText", TRIM(data))


which goes fine as long as data doesn't contain any special characters, however with data being for example


'My garden is 500 m²'


it doesn't escape the ² (square character) which causes the document to be invalid as it should normally be escaped to ²


The idea was to build a UDF that does this so I could write


XMLELEMENT(NAME "DescriptionText", myUDF(TRIM(data)))


however this results in


'My garden is ²'


which is invalid since XMLELEMENT does escape the standard characters like <, > and &.


It looks like there's no solution to this problem... or how are other people handling this ?


Kind regards,

Paul