• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

Storing Tiff and PDF images in SQL Server 2000

Is it possible to store Tiff images and PDF files in SQL Server.  If it is then how do you go about doing so.
0
thomashospital
Asked:
thomashospital
  • 3
1 Solution
 
twoboatsCommented:
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 ;)
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
You need to read those files as binary from your application and store it in a VARBINARY(MAX)  column
0
 
twoboatsCommented:
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.

0
 
thomashospitalAuthor Commented:
Decided not to put in SQL because the cons out weight the pros
0
 
twoboatsCommented:
Cool.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now