Thursday, March 10, 2011 4:28 PM
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
- Moved by Sethu SrinivasanMicrosoft Employee, Moderator Tuesday, August 14, 2012 1:33 AM express (From:SQL Server Distributed Replay)
Tuesday, March 15, 2011 1:29 PMYou need to convert the image to byte.
Wednesday, August 31, 2011 3:29 PM
I have a Microsoft SQL Server Express Edition with Advanced Services
and I do have image data type
/****** Object: Table [dbo].[TestImage] Script Date: 08/31/2011 11:23:07 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[TestImage](
[id] [int] NOT NULL,
[Visual] [image] NULL
Wednesday, August 31, 2011 6:09 PMTry to run the query (create table) in the SSMS.
Tuesday, July 03, 2012 2:27 PM
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...