Prev: Indexing Errors with Reporting Service Excel Exports
Next: DataSet Tables to SQL Server database
From: DavidC on 26 Jan 2010 12:01
Is it best to use an image data type or varchar(max) to store a TIF or JPG
file? We have some small signature images that we want to store in the
database rather than the filesystem. We will be updating via asp.net web
page. Thanks.

--
David
From: Plamen Ratchev on 26 Jan 2010 12:13
It is best to use VARBINARY(MAX). On SQL Server 2008 you can use FILESTREAM, but for small images probably just
VARBINARY(MAX) is fine.

--
Plamen Ratchev
http://www.SQLStudio.com
From: m on 26 Jan 2010 19:07
Also note that image has been superseded by varbinary(max) in SQL 2008. If
you are using an older version, then you should use image

"Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
news:hIGdnYsfOdpbv8LWnZ2dnUVZ_opi4p2d(a)speakeasy.net...
> It is best to use VARBINARY(MAX). On SQL Server 2008 you can use
> FILESTREAM, but for small images probably just VARBINARY(MAX) is fine.
>
> --
> Plamen Ratchev
> http://www.SQLStudio.com

From: Kalen Delaney on 26 Jan 2010 23:46
varchar(MAX) and varbinary(MAX) were added in SQL Server 2005.
Text and image are deprecated.

--
HTH
Kalen
----------------------------------------
Kalen Delaney
SQL Server MVP
www.SQLServerInternals.com

"m" <m(a)b.c> wrote in message news:en5ZnSunKHA.1556(a)TK2MSFTNGP05.phx.gbl...
> Also note that image has been superseded by varbinary(max) in SQL 2008.
> If you are using an older version, then you should use image
>
> "Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
> news:hIGdnYsfOdpbv8LWnZ2dnUVZ_opi4p2d(a)speakeasy.net...
>> It is best to use VARBINARY(MAX). On SQL Server 2008 you can use
>> FILESTREAM, but for small images probably just VARBINARY(MAX) is fine.
>>
>> --
>> Plamen Ratchev
>> http://www.SQLStudio.com
>
From: Michael C on 28 Jan 2010 18:43
"DavidC" <dlchase(a)lifetimeinc.com> wrote in message
news:35AF87C7-ACDD-45B7-A1C7-188CCD28AD5E(a)microsoft.com...
> Is it best to use an image data type or varchar(max) to store a TIF or JPG
> file? We have some small signature images that we want to store in the
> database rather than the filesystem. We will be updating via asp.net web
> page. Thanks.

Always store your data using the data type designed for the job. Varchar is
designed to store text, not images.

Michael


 |  Next  |  Last
Pages: 1 2
Prev: Indexing Errors with Reporting Service Excel Exports
Next: DataSet Tables to SQL Server database