List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 26 2002 4:20pm
Subject:Re: Re: sql command to examine blob data?
View as plain text  
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 table tbl1;
>
>PD> HEX() converts numbers, not strings.  There is no function in MySQL
>PD> for what you want.
>
>Now the situation is changed. :-)
>
>If the argument of HEX() is a string, HEX() returns a hexadecimal
>string of argument where each character is converted to 2 hexadecimal
>digits.

You're right!

This requires MySQL 4.0.1, so I assume the original poster is using
an older version.

>
>
>
>
>--
>For technical support contracts, goto https://order.mysql.com/
>This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
>/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
>

Thread
Re: Re: sql command to examine blob data?Victoria Reznichenko26 Apr
  • Re: Re: sql command to examine blob data?Paul DuBois26 Apr