How do I store graphics in mysql tables.

Cheers

Sales wrote:

Two ways
1.) Easiest and perhaps more often used: Don't do it. Save graphics in
some folder and then save only the name or a link to that graphic into
the database. For example if you have a webpage-system, create folder
"images" and move all images there and then just save the name of the
picture to database in normal text format.

2.) Save it in binary format, use column type BLOB for example.
http://dev.mysql.com/doc/mysql/en/BLOB.html

I am using delphi7. When I put a DBImage component looking at a blob column
and paste an image into the column I get the error 'My SQL Server has gon
away'.

This happen when I try to update the data grid by moving to the next record.


"Aggro" <spammerdream (AT) yahoo (DOT) com> wrote

Sales wrote:
I have never used the binary-method and I know nothing about Delphi, so
I can't help you, sorry.