What Mysql function can I use to examine blob in a table. I need to
display part of the blob in hex values. Shouldn't the following sql
command work :
select hex(substring(col1,1,10)) from table tbl1;
HEX() converts numbers, not strings. There is no function in MySQL
for what you want.
Paul,
Friday, April 26, 2002, 5:57:56 PM, you wrote:
What Mysql function can I use to examine blob in a table. I need to
display part of the blob in hex values. Shouldn't the following sql
command work :
select hex(substring(col1,1,10)) from table tbl1;
PD HEX() converts numbers, not
At 18:12 +0300 4/26/02, Victoria Reznichenko wrote:
Paul,
Friday, April 26, 2002, 5:57:56 PM, you wrote:
What Mysql function can I use to examine blob in a table. I need to
display part of the blob in hex values. Shouldn't the following sql
command work :
select hex(substring(col1,1,10)) from
Nissim,
Wednesday, April 24, 2002, 9:30:36 PM, you wrote:
NL What sql function can I use to examine blob in a table. I need to display
NL part of the blob in hex values. Shouldn't the following sql command work :
NL select hex(substring(col1,1,10)) from table tbl1;
Yes, you can use HEX() and