List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 26 2002 2:57pm
Subject:Re: sql command to examine blob data?
View as plain text  
>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.


Thread
sql command to examine blob data?Nissim Lugasy26 Apr
  • Re: sql command to examine blob data?Paul DuBois26 Apr