PDA

Click to See Complete Forum and Search --> : Image or Binary data type for uploading files?


Wokawidget
Sep 14th, 2004, 05:07 AM
I am writing an ASP.NET web page.
I want to be able to upload files to my server.
This I can do, I have found the code for this.
But when storing into DB I want to be able to store file sizes ranging from 1k to 10Mb.
What SQL Server datatype do i require for this?
I have the following table structure.

Downloads
ID (Identity)
Filename (String * 50)
FileData (Image * 16)

Is this correct?

Woof

CornedBee
Sep 14th, 2004, 05:39 PM
Blob is what the binary type is called in MySQL.

But with images, it's usually better to store them as files and store only the file names in the database.