Hi Rob, nice, thank you very much. Current version of mysql is 5.0.45, haven't tested the proposed solutions yet but I think using UTF-8 should undoubtedly solve the problem.
Joel 2007/9/17, Rob Marscher <[EMAIL PROTECTED]>: > On Sep 17, 2007, at 12:54 PM, Joel Sooriah wrote: > > having a problem right now concerning the use of accentuated > > characters in a xml document. > Are you storing the xml document in a mysql table? Which version of > mysql? > > You need to make sure that the character sets match all the way from > the database layer down through your web server - using utf8 is a > safe bet. > > > Of course, this is causing me much > > problem concerning the validity of my document, due to the use of ';' > > in the textContent of my node. > Using CDATA would solve that problem: > http://www.w3schools.com/xml/xml_cdata.asp > > -Rob > > _______________________________________________ > New York PHP Community MySQL SIG > http://lists.nyphp.org/mailman/listinfo/mysql > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php > _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
