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.