I finally know what the problem is.
The problem is the new ODBC Driver (3.51.08). I wasn't sure until today,
because i uninstalled it (at least that's what i tried) and installed
version 3.51.06 again. But when i went to see the MyODBC3.DLL file it was
still version 3.51.08!! So i deleted this and MyODBC3D.DLL files,
installed driver 3.51.06 again and now the datetime fields are working...
is it a bug?
----- Forwarded by Félix Beltrán Ramos/dap on 21/07/2004 08:21 p.m. -----
Félix Beltrán Ramos/dap
15/07/2004 11:30 p.m.
To
Sergei Golubchik <[EMAIL PROTECTED]>
cc
[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_field is null or blob_field=''
but problems continues... when i build a query that includes a datetime
field, i get weird information. I debuged the application and instead of
the datetime information, the recordset returns an string of 19 bytes...
The grid on the UI interprets this information like japanese (or other)
characters.
Looks like the problem is in the ODBC driver, because another cliente
machine connected to the same database doesn't get that results, and if
the computer with this problem connects to another server with an
identical database, it gets the same results...
Has anyone ever seen this before??
FBR
Sergei Golubchik <[EMAIL PROTECTED]>
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 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
