image in mysql

[mikawhat]

with asp and ms access you can use the path of the image in a database field in order to display the image. is that possible with mysql? or the only way is to create a script that inserts the image into the database?

[MikeSnead]

Sure you can... it's just a line of text like a username or password.

It's just more fun to store the image as a blob in the database :p

[mikawhat]

i can't imagine how this could be fun 😛
so i create a new field in my db, as a blob, and i just insert the path? (e.g. images/image.jpg)

[MikeSnead]

Nope, it's just a line of text so I would use the varchar() data type. Something like

create table images (
img_id int not null primary key auto_increment,
img_path varchar(50) not null
);

You'd use a blob data type if you were going to store the actual image file into the database.

[mikawhat]

i see!
thanx a lot for your help.