January 19, 2007 at 7:38 am
One of our developers is asking to store images in a database for a new application we are doing.
I did some quick research and see from MS Books Online that the image datatype is due to be axed in future versions of SQLServer now that there is varbinary(max) data type.
Wondered if anyone has had experiance putting images in the database using the new varbinary(max) data type and how it works out.
I know everything reccomends against doing this, but it's going to be a fairly small db (less than 1000 records) and 100K or less image sizes, so I don't see a problem with it in this case.
The Redneck DBA
January 19, 2007 at 1:03 pm
I have not used it so for... but based on the size it should not be a problem.
If there is any datatype changing will not take much time due to table size.
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply