How can I add an image to a table in Perl?

Question

I have developed a database using Perl DBI and display using Perl CGI. Can you please suggest syntax for adding an image to the table and its background in the database.

Answer 1

I would just insert a text field containing the address/name of the image, place the images in a directory and load them at runtime.

Answer 2

Insert the binary data into a field defined to hold blobs. Just be certain that only binary data gets inserted. Insertion can be done the same way you insert text into a text field.

You can also store the path to the image in a text field and later retrieve the image via that path.