MySQL Forums
Forum List  »  Connector/ODBC

ADODB, 32 bit MySQL ODBC 5.2 Unicode: Tables with multiple blob fields fail
Posted by: Rene Roessler
Date: July 07, 2013 02:54PM

Hi,
I have found a problem with 32bit ODBC Unicode Driver:

When I try to insert a record in a table with more than one BLOB field, I will get a buggy result, but no Errors are thrown.

The table has the following structure:

delimiter $$

CREATE TABLE `sce_usernames` (
`SUsername` varchar(50) NOT NULL DEFAULT '',
`SUserPassword` blob,
`SUserRights` blob,
PRIMARY KEY (`SUsername`),
UNIQUE KEY `SUsername_UNIQUE` (`SUsername`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$

When I try to insert a record with ADODB

SUserName = 'Admin' and filled BLOB data, I will get the result

Empty SUserName, SUserPassword NULL, SUserRights BLOB

The same Statement works with MS SQL Server 2008, Access.

I suppose the ODBC Driver has a bug handling tables with more than one blob, because tables with only one blob field are handled correctly.

Thanks for helping me with this issue

René

Options: ReplyQuote


Subject
Written By
Posted
ADODB, 32 bit MySQL ODBC 5.2 Unicode: Tables with multiple blob fields fail
July 07, 2013 02:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.