Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > Database tables

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Database tables

Reply to Message Icon

Name: Lino
Date: September 23, 2009 at 21:38:24 Pacific
OS: Windows XP
Subcategory: MS SQL Server
Comment:

what will be the constraints and data type used for storing or uploading a photo to an online project database table



Sponsored Link
Ads by Google

Response Number 1
Name: frankjustme
Date: September 27, 2009 at 19:02:42 Pacific
Reply:

varbinary will hold up to 8000 bytes. These columns are defined as varbinary(size) or VARBINARY(MAX) FILESTREAM. The 2nd option stores the binary outside the database. This will make the DBA happier as it will not consume database space. When the filestream option is used the files are stored in the same directory as sqlserver files for the database.


1
Reply to Message Icon

Related Posts

See More


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: Database tables
Can Access open Oracle tables www.computing.net/answers/dbase/can-access-open-oracle-tables/138.html

Excel sheets linked to database tables www.computing.net/answers/dbase/excel-sheets-linked-to-database-tables/679.html

SQL Server 2000 Restore www.computing.net/answers/dbase/sql-server-2000-restore/251.html