No such thing as a small change | |
PerlMonks |
Re: storing files with dbi & sqlserverby gmax (Abbot) |
on May 04, 2003 at 20:39 UTC ( [id://255518]=note: print w/replies, xml ) | Need Help?? |
MS SQL has some different BLOB types, such as IMAGE, TEXT and NTEXT, which you can use according to your needs. As for inserting them into the database, you may use the same upload subroutine that you saw in my node about BLOBs, without the stuff about max length. However, be aware that inserting large objects in a database through DBI may be tricky. Check the DBI documentation about LongReadLen and LongTruncOK before attempting to achieve your goal. That aside, retrieving variables from BLOBs is not different from other types.
HTH
In Section
Seekers of Perl Wisdom
|
|