Connecting Tech Pros Worldwide Help | Site Map

insert image path into longblob

Member
 
Join Date: Jan 2009
Location: USA
Posts: 118
#1: Jul 28 '09
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:
Expand|Select|Wrap|Line Numbers
  1. create table test(
  2. testid bigint unsigned not null,
  3. testpath longblob)
  4. engine=innodb
  5.  
Expand|Select|Wrap|Line Numbers
  1. insert into test ( 
  2. testid,
  3. testpath)
  4. values
  5. (
  6. '1',
  7. '/var/www/test/test.jpg'
  8. )
  9.  
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's Avatar
Member
 
Join Date: Jul 2009
Location: Israel
Posts: 85
#2: Jul 28 '09

re: insert image path into longblob


Why longblob? I'd prefer longtext for this one, or a varchar...
Member
 
Join Date: Jan 2009
Location: USA
Posts: 118
#3: Jul 28 '09

re: insert image path into longblob


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