Use or not BLOB fields with SQL Server

Use or not BLOB fields with SQL Server

• bthumber

  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.
  
  
  

• Ryan McCauley

  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.
  

• Ashu283

  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.
  
  
  
  

• Mark_Wilhelm

  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
  

• splyf

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

  
  
  

• Sonkit

  Thanks Craig, Thanks Cetin,
  
  Regards,
  
  Ana
  Madrid, Spain
  www.amby.net
  www.PortalFox.com
  
  
  
• Use or not BLOB fields with SQL Server