|
Hi Thanks guys. You are right Neven, they aren't the same chars. When I looked closer the problem is actually in the source data. Some how when the client has cut and pasted text into a plain TMemo they have copied accross all sorts of funny chars, even bullets ! Cleaning the source data fixes the problem :) Merry Xmas all :) Rob On 18/12/2009 6:38 p.m., Neven MacEwan wrote: 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'sHTH NevenHi 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 |
_______________________________________________ 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
