Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ya3mro
Starting Member
37 Posts |
 Posted - 2006-06-15 : 09:09:18
|
| if i make a column of type BINARY and i will store vedio files in itWhat's Max Size of Vedio File that i can Save in this Field ??and i want any relates Articles about this idea ?thanx for ur interestHow I Came To Islam? http://english.islamway.com |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-15 : 09:28:21
|
| For SQL 2000, the max size for binary is 8,000 bytes. For 2005 I think it is 2,147,483,647 bytes.Peter LarssonHelsingborg, Sweden |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-15 : 09:36:12
|
| Store only physical path of the files in the column and store files in the server directoryhttp://www.aspfaq.com/show.asp?id=2149 http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspxMadhivananFailing to plan is Planning to fail |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-16 : 02:36:43
|
| BINARY and VARBINARY can hold 8000 bytes, IMAGE can hold 2GB. In 2005 there is a special case VARBINARY(MAX) that like IMAGE can hold up to 2GB as well.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
|
|
|
What is Binary Max Size ?