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, 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.