datatype to store files

• gyessql

  Ten Centuries

  Points: 1097

  More actions

  April 4, 2009 at 10:34 am

  #132896

  Can we store files like pdf in varchar(max) or nvarchar(max) datatype? Is there any other datatype that can be used to store the files?

• Jeff Moden

  SSC Guru

  Points: 1004372

  More actions

  April 4, 2009 at 11:30 am

  #972089

  I would imagine that IMAGE or VARBINARY would do the trick. See Books Online for the details.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 4, 2009 at 2:51 pm

  #972105

  I would suggest VARBINARY(MAX) because IMAGE is marked as deprecated and will be removed in future versions of SQL Server (I still don't completely understand why...).

  If you use SQL Server 2008 you can also use FILESTREAM which was (also) introduced for WinFS (which is dead).

  Greets

  Flo

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9119

  More actions

  April 6, 2009 at 9:17 am

  #972622

  There is one intresting article on VARBINARY vs FILESTREAM datatypes.

  http://coolthingoftheday.blogspot.com/2009/01/sql-server-varbinary-vs-filestream-code.html

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers