MySQL Forums
Forum List  »  Connector/ODBC

Re: Mysql ODBC 8.0.15 SQLFetch returns SQL_NO_DATA for a Select query with where clause if one of the selected fields is blob. Works fine for 5.3.6
Posted by: Peter Brawley
Date: February 20, 2019 11:07AM

You say version 5.3.6, which doesn't exist. Assuming you meant 5.6, in that version the query runs fine. Likewise in 8.0.14. In both cases I ran ...

set @sql = "SELECT `Num`,`Alpha`,`myBlob` FROM `b306_Blob_Last` WHERE `Num` BETWEEN ? AND ? ORDER BY `Num`" ;
prepare stmt from @sql;
set @a=2, @b=3;
execute stmt using @a, @b;
drop prepare stmt;

So the problem must your prepare/execute code. Let's see it.

Options: ReplyQuote

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.