Re: Microsoft Access DB & MySQL 5.7 & longblob
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
Subject
Written By
Posted
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.