MYSQL and Image Storage (1 Viewer)

[Steve R.]

In Access, the preferred approach to store an image is as a file external to the database. Is that the case with MYSQL?

 

[plog]

Yes it is.

 

[Steve R.]

Yes it is.

OK. I'll Have to work on that. Thanks.

 

[abubasil]

what if i wanted to store the image itself in the mysql database not only the name? is that possible? if it is possible is it an idea to use the binary internal data of a stored small pic as authentication value for login? is this the idea with the loging seal used by yahoo website ?????

 

[plog]

I believe its possible, but not the ideal way. I think you want a BLOB field type (BLOB, MEDIUMBLOB or LONGBLOB) for an image file. Search the net to see what people say about doing it your way instead of storing just the image location.