# Supressing Special Characters in XML MySQL driven data

**URL:** <https://forum.kirupa.com/t/supressing-special-characters-in-xml-mysql-driven-data/297077>\
**Category:** flash\
**Created:** [September 25, 2009, 8:44am UTC](https://forum.kirupa.com/t/supressing-special-characters-in-xml-mysql-driven-data/297077 "2009-09-25T08:44:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hagop](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@hagop](https://forum.kirupa.com/u/hagop)\
**Post date:** [September 25, 2009, 8:44am UTC](https://forum.kirupa.com/t/supressing-special-characters-in-xml-mysql-driven-data/297077/1 "2009-09-25T08:44:29Z")

</div>

Hi all

I have a dynamic text field in Flash CS4 which gets its value via XML from a back-end MySQL database.  
The issue is that I want to make the text field to display HTML text

my\_txt.htmlText= \<a href="[http://www.pantene.com](http://www.pantene.com)\>"PANTENE COMPANY\</a\>

However, there is a problem in Flash both AS2 & AS3 and both CS3 & CS4 in the sense that when there are special characters ie: double quotation marks ", the XML loader does not read (retrieve) any data from the database.

How can I suppress these special characters ? How can I find a workaround ?

Thanks  
Hagop