Bill, I do this for JPEGs, TIFs, PDFs, etc, by just storing the filename in the database. The actual BLOB file remains stored in the host O/S filesystem. You may need to work out your own simple hierarchial directory structure to limit the number of files per sub-directory; in my case I typically assign the BLOB file a sequential name, e.g. 1234999.pdf, then store a maximum of 1000 files per directory as .../1234/1234999.pdf. A standardized subroutine calculates and returns the path to the file based on it's name.
/Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Wed, Oct 8, 2008 at 11:01 AM, Brutzman, Bill <[EMAIL PROTECTED]>wrote: > Is there a way to save a file with a photograph in a U2 database? > > I seem to remember the idea of a BLOB (Binary Large Object) data type in > say MS-SQL. > > Suggestions would be appreciated. > > --Bill > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
