Re: Escaped BLOB data in XML

2004-08-13 Thread Paul DuBois
At 10:46 -0700 8/12/04, Karam Chand wrote: Hello, 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: data data ... ... Now the problem is even if I mysql_real_escape() and changing entities like <,> to < & > the data some o

RE: Escaped BLOB data in XML

2004-08-13 Thread Chris Blackwell
: Re: Escaped BLOB data in XML 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 fi

Re: Escaped BLOB data in XML

2004-08-12 Thread Karam Chand
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 esca

Re: Escaped BLOB data in XML

2004-08-12 Thread Karam Chand
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

Re: Escaped BLOB data in XML

2004-08-12 Thread Keith Ivey
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: data data ... ... Now the problem is even if I mysql_real_escape() and changing entities like <,> to < & > the data some of the characters are of ascii v