Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: PDF stored as binary
Thread ID: 112459 Message ID: 112469 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, November 08, 2006 9:34:43 PM         
   


> > Has anybody stored PDF or JPG files in binary format on a SQL Server? I've got a need where I'd much rather have a PDF or JPG converted to binary format and then saved in a SQL record. I'm not sure if this is possible, or even advisable. I'm thinking maybe a hundred pages worth of docs or images in a particular day. Disk space is not an issue, but performance would be.
> >
> > Any insights would be appreciated.
> >
> > Thanks,
> > David

>
> David,
>
> I deal with a LOT of image files (30,000+ per year) and I wouldn't even dream of storing them in a table. Where I need to, I store the path and filename in my table and then access the image/pdf/what ever directly.
>
> If you must, you can store these images in a BLOB or BinaryMemo field. Look at FILETOSTR() and STRTOFILE() in help.
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)


Ken, I am stronger supporter of keeping external files OUT of tables, but when you dealing with SQL server things are different. You may have NO access to disk where SQL Server is installed. Local stations may have no common shared folder where you can keep these files. Only option available (when you works with SQL Server) is to store these files IN image field of the tables (of course if you want they to be visible to ALL users, not only to user who store them).

Borislav Borissov



ENTIRE THREAD

PDF stored as binary Posted by David Jo @ 11/8/2006 8:48:38 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:04:55 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:08:47 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:31:51 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:39:48 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/8/2006 9:44:46 PM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:50:37 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:20:11 AM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:56:03 PM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:18:19 AM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:34:43 PM
RE: PDF stored as binary Posted by Ilya Rabyy @ 11/9/2006 12:09:54 AM
RE: PDF stored as binary Posted by Ken Murphy @ 11/9/2006 12:28:00 AM
RE: PDF stored as binary Posted by Ilya Rabyy @ 11/9/2006 12:35:40 AM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:37:32 PM
RE: PDF stored as binary Posted by David Jo @ 11/8/2006 9:42:49 PM
RE: PDF stored as binary Posted by Borislav Borissov @ 11/8/2006 9:47:42 PM