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
>
