Is there any way to hex-dump a BLOB column using a Select statement on the
mysql command line?
The documentation for the "hex()" function says that
hex("abc")
should print
616263
But in fact it prints 0. (on 3.23.36 and 3.23.43, the two versions I have
installed - the former on RedHat 7.1, and the latter on Windows2K).
Even if it worked, would it work on an entire BLOB column?
Even better, is there any way to export just a single BLOB column of a
single row to a binary file, unadorned by CSV or HTML guff?
P.S. I also tried the following commands:
(echo "connect mydb;" ; \
echo "select blobcol from table where id=1" ) |\
mysql -s > OUT
This works, but prints nulls as the string "\" followed by "0".
If I also specify "-r" for "raw", it truncates at the first
null instead of printing everything.)
Thanks,
--
Shankar.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
