Fw: 'x' on blob field when retrieving records

2004-07-21 Thread fbeltran
[EMAIL PROTECTED], [EMAIL PROTECTED] Subject Re: 'x' on blob field when retrieving records I haven't been able to reproduce the problem on another computer. I executed this query on control center and no longer get the 'x'... update table set blob_field=null where blob_fie

Re: 'x' on blob field when retrieving records

2004-07-15 Thread fbeltran
t; 14/07/2004 10:44 a.m. To [EMAIL PROTECTED] cc [EMAIL PROTECTED], [EMAIL PROTECTED] Subject Re: 'x' on blob field when retrieving records Hi! On Jul 13, [EMAIL PROTECTED] wrote: > I have a query like this > > select hex(blob_field) as myField from table > > When th

Re: 'x' on blob field when retrieving records

2004-07-14 Thread Sergei Golubchik
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

Re: 'x' on blob field when retrieving records

2004-07-13 Thread fbeltran
t;[EMAIL PROTECTED]> cc Subject 'x' on blob field when retrieving records 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. MySQ

'x' on blob field when retrieving records

2004-07-13 Thread fbeltran
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) Felix Beltran.