MYSQL and Image Storage (1 Viewer)

Steve R.

Retired

Local time

Yesterday, 23:54

Joined

Jul 5, 2006

Messages

4,673

• Feb 8, 2012

• #1

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

 

P

plog

Banishment Pending

Local time

Yesterday, 22:54

Joined

May 11, 2011

Messages

11,638

• Feb 8, 2012

• #2

Yes it is.

 

Steve R.

Retired

Local time

Yesterday, 23:54

Joined

Jul 5, 2006

Messages

4,673

• Feb 8, 2012

• #3

plog said:

Yes it is.

Click to expand...

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

 

A

abubasil

Registered User.

Local time

Today, 06:54

Joined

Aug 31, 2011

Messages

29

• Sep 22, 2012

• #4

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 ?????

 

P

plog

Banishment Pending

Local time

Yesterday, 22:54

Joined

May 11, 2011

Messages

11,638

• Sep 23, 2012

• #5

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.