How to Check Blob Size

• Nitin Rana-182398

  Say Hey Kid

  Points: 687

  More actions

  November 29, 2004 at 9:47 am

  #182960

  I have an image column in the table that stores PDF files. I need to check the size of a particular PDF document and compare it with actual file in NTFS system. Any suggestions on how to do it?

  -Nitin

• Scott Thornburg

  Hall of Fame

  Points: 3347

  More actions

  November 29, 2004 at 2:54 pm

  #531793

  Nitin,

  You can get the byte size of the image column by using the SQL function Datalength.

  select datalength(image_column) from MyTable

   

  Scott Thornburg

  Volt Information Sciences

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 30, 2004 at 12:53 am

  #531820

  May I ask, why you keep the file in an image column AND on the filesystem? Or do you need this to determine if the file was updated? Anyway, here's a very good link on BLOBs and SQL Server http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]