Insert/retrieve images from Mysql and Postgres tables.

[mike1]

I am looking for a way to put images into a Mysql and Postgres database table and retrieve the images from the table.

[chriskl]

In PostgreSQL, use the 'bytea' type, and in MySQL use the BLOB type.

Chris

[Sxooter]

Note that if you want it to be somewhat more easily portable, you could also base-64 encode it, then store it in a varchar() or text field.