Use or not BLOB fields with SQL Server

Hot Topic

Limit edit box
How to know DELETE SQL to be success
Should we inactive the MENU ?
Help?
HOW I CAN DO "WIZARD UPSIZING" FROM THE SOURCE CODE??
Export data to text- How I can bypass the default text delimitter?
data from one table1 that isn't in table2
like command
Cursor help
foxpro dos program convert to foxpro window (any)

Visual FoxPro

Foxpro is DBMS or RDBMS? and Why?
records disappear forom tables
Drew Speedie Dies in Accident
show certain record in gridbox
FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02
a child form needs 2 clicks to close
How to get the UserID and password login to windows in Visual Foxpro?
Need solution for complex query
problem with physical sorting
Accessing FoxPro from C++

Use or not BLOB fields with SQL Server

Hi:

We are deciding which would be the better approach for managing a lot of files (PDF, JPG, DOC, DWG, ETC.). We are speaking about thousand of files and thousand of megabites.

As far as we are developing with VFP 9.0, we would be able to use BLOB fields. But we are not sure if it will be the best choice for us, taking in account, the amount and sizes of the files.

Could anyone help us

Regards,

Ana
Madrid, Spain
www.amby.net
www.PortalFox.com


Answer this question

Use or not BLOB fields with SQL Server

  • RobertHernandez

    No. I don't think it would. Besides having access to the database (for the anti-virus), the BLOB itself is encoded, not the original binary, so it wouldn't work.

    Same for VFP's BLOB field type.

  • Janaka

    Thanks Craig, Thanks Cetin,

    Regards,

    Ana
    Madrid, Spain
    www.amby.net
    www.PortalFox.com


  • Zhaph

    Either BLOB, Memo binary or General field would be a good choice (I don't mean to use general fields as general fields on form but simply as a storage) IF you'd store them with data. Otherwise simply keeping the path and filenames would do. Managing Memo binary or general fields with SQL server's image datatype is a little tricky. I'd choose new BLOB datatype which is much easier to handle and even for short data directly might fill with a literal hex string as you could do with an SQL image type.
    All 3 have available memory and/or 2Gb limit.

  • Ted Curtsinger

    If you use Blob fields and a file with a virus is put in that field, would and anti-virus software be able to see that file and clean it

  • Piggy

    None of the above. Store the image as a separate file. Have a field that stores the filename.



  • whisnart

    None of the above Come on Craig, it's a suggestion not to store the file itself (as I noted) however in real world applications there are times you need to store it directly in database. If you're talking about thousands and maybe millions of files + SQL server it might be better to store them in the database than to store just path.
  • Use or not BLOB fields with SQL Server
Answer this question