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:
<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.
I assume you mean mysql_real_escape_string(), not
mysql_real_escape()?
mysql_real_escape_string() is intended for escaping data that
you are including in statements to be sent *to* the server.
It is not for escaping data that you get back *from* the
server in the result from a query.
The issue you're describing is an XML issue, not a
MySQL issue. You'll probably get more help if you post
your question (which boils down to "how can I write out
binary data to an XML file?") on an XML-related list.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]