Robert I think you should encode the single quotes in the XML, &apos? I note in your example rob`s is not the same as rob's
HTH Neven > Hi all > > I have some code that takes data and converst into XML that is sent to a > web site and processed by a Php script into a MySQL Db. This works > pretty well but I have just discovered that text with a ' i.e. rob's > gets stored in MySQL as rob’s > > If I look at the XML in notepad on my pc i see > > <FIELDNAME>rob`s</FIELDNAME> > > so it looks like my XML is ok but when its imported it gets scrambled. > Any suggestions? > > Thanks > Rob > > _______________________________________________ > NZ Borland Developers Group Offtopic mailing list > Post: [email protected] > Admin: http://delphi.org.nz/mailman/listinfo/offtopic > Unsubscribe: send an email to [email protected] with > Subject: unsubscribe > > > _______________________________________________ NZ Borland Developers Group Offtopic mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/offtopic Unsubscribe: send an email to [email protected] with Subject: unsubscribe
