I am trying to store an image into sql express 2008 and retrieve it on a php page.
I used the following query to do the storing:
CREATE TABLE Employees
Name varchar(50) not null,
Photo varbinary(max) not null
INSERT INTO Employees (Id, Name, Photo) SELECT 10, 'John', BulkColumn from Openrowset( Bulk 'C:\n502696575_60323_4407.jpg', Single_Blob) as EmployeePicture
then when I tried to retrieve it on my php page. only 1/3 of the image gets displayed. the image I uploaded was about 20kb in size, so I don't think it's because varbinary got maxed out. Can any one tell me what is going on?
View Complete Post