Re: Microsoft Access DB & MySQL 5.7 & longblob

[Bogdan Degtyariov]

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