insert image path into longblob

[wizardry]

hello -

ive inserted user names, etc. into the longblob but the path to the image is giving me a bit of a trouble.

do i need to change a mimi type or transformation of some sort?

i've changed it, to try to see it it would work but nothing.

ok here is the table defenition that im uploading the path to:

create table test(
testid bigint unsigned not null,
testpath longblob)
engine=innodb
 

insert into test ( 
testid,
testpath)
values
(
'1',
'/var/www/test/test.jpg'
)
 

what i want to do is use the file system, and insert that path not the image into the database.

thanks in advance for your help

[Canabeez]

Why longblob? I'd prefer longtext for this one, or a varchar...

[wizardry]

because if i want to encrypt it it can be done.

[utarynda]

yes, and there are some people want this data type. if you know how to do it, please share