I just added a user variable @fdata to get visabilility outside of the
procedure and this is what I get.
mysql delimiter //
mysql create procedure test20 ()
-BEGIN
- DECLARE fdata BLOB;
- DECLARE foffset INT UNSIGNED;
- DECLARE flength INT UNSIGNED;
-
Gordon,
...
SELECT CONVERT(fdata,BIGINT) INTO tmp_int;
SELECT HEX(tmp_int);
...
Are you looking for...
SELECT CAST(0xABCDEF0123456789 AS UNSIGNED);
+--+
| CAST(0xABCDEF0123456789 AS UNSIGNED) |
+--+
|
I forgot to do reply all, sorry peter for the duplicate:
Thank you for the responses to my question, however with a little poking
around after the suggestions, I still am unable to do the conversion.
mysql select 0xABCDEF0123456789 into @fdata;
Query OK, 1 row affected (0.00 sec)
mysql select