transform text

[alain dhaene]

HI,

I retrieve data from a text box. I store this in a mysql db and later I
retrieve the data and make a xml-format.

This works but when I put characters such as é I have problems to make the
xml-format.

Is there a way to transform the text from the text box in a ascii format and
then store this in the db?

thx,

Alain

[Berislav Lopac]

alain dhaene wrote:

HI,

I retrieve data from a text box. I store this in a mysql db and later
I retrieve the data and make a xml-format.

This works but when I put characters such as é I have problems to
make the xml-format.

Is there a way to transform the text from the text box in a ascii
format and then store this in the db?

You need to specify the encoding in the XML file.

Berislav

--
If the Internet is a Marx Brothers movie, and Web, e-mail, and IRC are
Groucho, Chico, and Harpo, then Usenet is Zeppo.

[Tony Marston]

If you are using PHP's XML DOM functions to create your XML data then take a
look at http://www.tonymarston.co.uk/php-mys...tml#multi-byte which
explains how to deal with multi-byte character sets.

--
Tony Marston

http://www.tonymarston.net
"alain dhaene" <a.******@instruct.be> wrote in message
news:40***********************@news.skynet.be...

HI,

I retrieve data from a text box. I store this in a mysql db and later I
retrieve the data and make a xml-format.

This works but when I put characters such as é I have problems to make the xml-format.

Is there a way to transform the text from the text box in a ascii format and then store this in the db?

thx,

Alain

[Chung Leong]

"alain dhaene" <a.******@instruct.be> wrote in message
news:40***********************@news.skynet.be...

HI,

I retrieve data from a text box. I store this in a mysql db and later I
retrieve the data and make a xml-format.

This works but when I put characters such as é I have problems to make the xml-format.

Is there a way to transform the text from the text box in a ascii format and then store this in the db?

UTF-8 is the preferred method of encoding character data in XML. Pass the
text through utf8_encode() before you place it into the XML file.