Why does Data Type Image not work in SQL 2008 express edition

Question

I'm working with a project thesis which consists on a webstore, i'm using a Table named products in SQL Express Edition 2008, which i'm using image as a DataType to insert the product images, however when i tried to fill the data on image data type apperas the message Invalid value for cell (row 1, column 7) The changed value in this cell was not recognized as valid .NetFramework Data Type:Byte[]

What is the reaseon is not accepting the  .jpg in image data type

Answer 1

You need to convert the image to byte[].

Answer 2

I have a Microsoft SQL Server Express Edition with Advanced Services
Version 10.50.1617.0

and I do have image data type

/****** Object:  Table [dbo].[TestImage]    Script Date: 08/31/2011 11:23:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TestImage](
 [id] [int] NOT NULL,
 [Visual] [image] NULL
)

GO

 

---

mysorian

Answer 3

Try to run the query (create table) in the SSMS.

Answer 4

Hi,

I tried and the result is a max length of 16 - I can store images into the field converting then into byte[], I can read them again, but the result is a bytearray with the lenght of 16...

Oli