[Solved] MySQL BLOBs and Base don't seem to work
Posted: Thu Feb 25, 2021 6:48 pm
I'm on Debian 10, using LO 7.1 and MariaDB 10.5.8-MariaDB-1:10.5.8+maria~buster. I connect Base directly via a socket.
I have created a table and a form based on the table:
When I upload an image, it disappears as soon as I save it. I have found several questions about this, but the answers never seem to address the problem or suggest ways to troubleshoot it.
I know from working with Java EE, that it is perfectly possible to store and retrieve images in MySQL/MariaDB, so the problem isn't the database. Is there anything one needs to do, other than naively following the wizard?
Edit:
This works perfectly when I use JDBC, but not with ODBC or connecting through a socket.
I have created a table and a form based on the table:
Code: Select all
MariaDB [greenhouse]> desc plant;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| genus | varchar(128) | YES | MUL | NULL | |
| species | varchar(128) | YES | | NULL | |
| picture | blob | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
4 rows in set (0.210 sec)
I know from working with Java EE, that it is perfectly possible to store and retrieve images in MySQL/MariaDB, so the problem isn't the database. Is there anything one needs to do, other than naively following the wizard?
Edit:
This works perfectly when I use JDBC, but not with ODBC or connecting through a socket.