MySQL Forums
Forum List  »  Connector/ODBC

Re: Microsoft Access DB & MySQL 5.7 & longblob
Posted by: Bogdan Degtyariov
Date: May 19, 2020 06:22AM

I was able to edit data in MS Access without any problems.
The table is as follows:

create table lb_test (id int primary key auto_increment, vc varchar(32), lb longblob);

Then I added a new row and inserted a 1MB PDF document into LONGBLOB. The insert worked, updating the row with new values worked as well.
Used MySQL Connector/ODBC 8.0.20

Options: ReplyQuote

Written By
Re: Microsoft Access DB & MySQL 5.7 & longblob
May 19, 2020 06:22AM

Sorry, only registered users may post in this forum.

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.