blob data type in SQL Express

Hi all,

I am trying to store binary datafiles into a SQl Express table. However I can not find the BLOB data type when I am designing the table. Are we limited to using that kind of data type in the Express edition? Thanks.

Ke

hi Ke,

if you are searching for a BLOB datatype, you'll miss it..

SQLExpress does support blobs in different formats, binary, varbinary, image and text/ntext as long as the new datatypes as varchar(MAX), nvarchar(MAX), varbinary(MAX), XML

use tempdb;

GO

CREATE TABLE dbo.testBlob (

Id int NOT NULL PRIMARY KEY,

b varchar(max),

i image,

b2 varbinary (50)

);

GO

DROP TABLE dbo.testBlob ;

I've just run SQL Server Management Studio Express, the official graphical client tool for SQLExpress, available for free download at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en, and the relative datatypes are listed in the datatypes combobox when editing tables...

please have a look at http://msdn2.microsoft.com/en-us/library/ms187752.aspx for all supported data types..

regards