File Storage

I am seeking some suggestion of storing files in SQL Server, currently I have
a lot of files ~1MB each. I am to store them into the database, what kind of
data type should I use? Binary? Varbinary? It seems that Binary/Varbinary
support file up to 8000bytes only, is that true? Thx.Hi
Look at the datatype 'Binary'. It supports up to 2GB. It is referred to as a
BLOB in many places. There are a few code examples on microsoft.com on how to
store and retrieve the data.
Regards
Mike
"Sean" wrote:
> I am seeking some suggestion of storing files in SQL Server, currently I have
> a lot of files ~1MB each. I am to store them into the database, what kind of
> data type should I use? Binary? Varbinary? It seems that Binary/Varbinary
> support file up to 8000bytes only, is that true? Thx.|||The SQL data types that support 'blobs' (> 8000 bytes) are text, ntext and
image. Choose the data type that is appropriate for the underlying file
contents.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:192C9D72-3B5F-4A92-963F-EBA82FBDF831@.microsoft.com...
>I am seeking some suggestion of storing files in SQL Server, currently I
>have
> a lot of files ~1MB each. I am to store them into the database, what kind
> of
> data type should I use? Binary? Varbinary? It seems that Binary/Varbinary
> support file up to 8000bytes only, is that true? Thx.

File Storage

I am seeking some suggestion of storing files in SQL Server, currently I have
a lot of files ~1MB each. I am to store them into the database, what kind of
data type should I use? Binary? Varbinary? It seems that Binary/Varbinary
support file up to 8000bytes only, is that true? Thx.
Hi
Look at the datatype 'Binary'. It supports up to 2GB. It is referred to as a
BLOB in many places. There are a few code examples on microsoft.com on how to
store and retrieve the data.
Regards
Mike
"Sean" wrote:

> I am seeking some suggestion of storing files in SQL Server, currently I have
> a lot of files ~1MB each. I am to store them into the database, what kind of
> data type should I use? Binary? Varbinary? It seems that Binary/Varbinary
> support file up to 8000bytes only, is that true? Thx.
|||The SQL data types that support 'blobs' (> 8000 bytes) are text, ntext and
image. Choose the data type that is appropriate for the underlying file
contents.
Hope this helps.
Dan Guzman
SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:192C9D72-3B5F-4A92-963F-EBA82FBDF831@.microsoft.com...
>I am seeking some suggestion of storing files in SQL Server, currently I
>have
> a lot of files ~1MB each. I am to store them into the database, what kind
> of
> data type should I use? Binary? Varbinary? It seems that Binary/Varbinary
> support file up to 8000bytes only, is that true? Thx.