What database are you using? if Sql Server 2000 the general rule is to just save the path to the file in the database. The logic being: Files belong in a file system not a relational database. But, you can store files in binary format as BLOBS (Binary Large Objects) in the image datatype column of SqlServer 2000. In SqlServer 2005 you have varbinary(max) datatype which is better.
Last edited by hollystyles; Sep 18th, 2007 at 12:50 pm.
Reputation Points: 262
Solved Threads: 68
Veteran Poster
Offline 1,181 posts
since Feb 2005