This leads me to another question. What are the valid ASCII characters that XML parser understands.
Are they only a-1,A-Z,0-9,., etc or some other characters. Regards, Karam --- Karam Chand <[EMAIL PROTECTED]> wrote: > Hello, > > Hmmm. I was figuring that out. mysql_escape_string() > only escapes characters like \r, \n, \\, 0 etc. it > still keep other non-character data same like it > keep > ascii 15 to ascii 15 that no parser is able to > handle. > > Isnt there any better way then base64 to handle > this. > Just like replacin < to < solves the problem in > the > data? > > Regards, > Karam > > --- Keith Ivey <[EMAIL PROTECTED]> wrote: > > > Karam Chand wrote: > > > > >i have a table with a LONGBLOB column. We store > > some > > >small images in it. I want to export them in XML > > >format with schema like: > > > > > ><c>data</c> > > ><c>data</c> > > >... > > >... > > > > > >Now the problem is even if I mysql_real_escape() > > and > > >changing entities like <,> to < & > the > data > > >some of the characters are of ascii value 12,13 > > etc. > > >None of the XML parsers are able to recognise it > > and > > >they throw up error? I googled but couldnt find a > > >refernce on how to handle such characters in XML. > > > > > > > > > > This doesn't have anything to do with MySQL. XML > > isn't really designed for > > directly containing binary data, so people > generally > > use Base64 encoding (or > > occasionally some other method of encoding binary > > data in ASCII). The XML > > parser isn't going to be able to return the raw > > binary data -- you'll > > have to > > decode it. > > > > -- > > Keith Ivey <[EMAIL PROTECTED]> > > Washington, DC > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - Helps protect you from nasty viruses. > http://promotions.yahoo.com/new_mail > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
