Storing Tiff and PDF images in SQL Server 2000

Posted on 2007-07-24
Last Modified: 2013-11-30
Is it possible to store Tiff images and PDF files in SQL Server.  If it is then how do you go about doing so.
Question by:thomashospital
    LVL 14

    Accepted Solution

    It is, you'd put them in an image type column.

    However, it's beeter and simpler to stored a path\filename for them, and store the files on your disk.

    NTFS for files, SQL for data ;)
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    You need to read those files as binary from your application and store it in a VARBINARY(MAX)  column
    LVL 14

    Expert Comment

    Gonna be smaill images in a varbinary...

    varbinary [ ( n ) ]

    Variable-length binary data of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length of the data entered + 4 bytes, not n bytes. The data entered can be 0 bytes in length. The SQL-92 synonym for varbinary is binary varying.


    Author Comment

    Decided not to put in SQL because the cons out weight the pros
    LVL 14

    Expert Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now