Hi!
On Jul 13, [EMAIL PROTECTED] wrote:
> I have a query like this
>
> select hex(blob_field) as myField from table
>
> When the blob field is empty ('') it returns 'x'.
>
> i'm using ADO with Visual Basic and MyODBC 3.51.
> MySQL Version is 4.0.18 and SO is Win XP Pro (also happens on Windows 2K)
If you can provide a repeatable test case, please submit a bugreport at
bugs.mysql.com
So far I was not able to repeat it:
mysql> create table a (b blob);
Query OK, 0 rows affected (0.01 sec)
mysql> insert a values (NULL), (''), (0), ('aaa');
Query OK, 4 rows affected (0.02 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> select hex(b) from a;
+--------+
| hex(b) |
+--------+
| NULL |
| |
| 30 |
| 616161 |
+--------+
4 rows in set (0.01 sec)
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
