Can you insert a picture into a database field. If so how?

I’m new to this software and would like to know how to insert a picture into a database field.

Can this be done ? If so how ?

Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale: en-US (en_US)
Libre office Database
Window 10 PC


Welcome to LibreOffice and this forum.

In the table that you want to insert pictures - make a field with a field type of Image [LONGVARBINARY].

In your form or report, insert the Image field and size it however you desire.

You enter pictures into this field by right clicking on the form field and selecting Insert Image from . . .

It then opens the file file browser for you to find and select the desired image file.

Once the field is populated you get an additional option to Remove Image, if desired.

Keep in mind that large image files will make a large database table that may slow things down a bit. Try to keep the picture resolution as low as possible (smaller file sizes).

Thanks for this. I was trying to insert directly into the table, but it has to be through a form.

I don’t have access to LO Data right now, so I’m writing “off the top of my head” from fairly extensive experience with MS-Access (which is similar).

You don’t actually “insert a picture into a database field.” Instead, you enter the link to the picture file (png, jpg, etc.) into the data table field. You then use a form or report, add a control for the picture, and reference the data table field as the underlying source for the control.

Please click the check mark next to my response if you believe it best answers your question.

I don’t think LO (at least with Firebird) gives the option of linking to a picture. The increase in the file size indicates that the image is inserted.