Sql query : store image along with image type in SQL

Question

1.00/5 (1 vote)

See more:

I want to acheive a query thats definitely stores an image in a column and also recognises the image type and stores the type in another column.

Examples of Image Type as in : PNG, JPEG.

I would now create a table like below

CREATE TABLE [dbo].[test3](
	[ImageID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [varchar](50) NOT NULL,
	[Image Type] [varchar](50) NOT NULL,
	[Image] [image] NOT NULL)

What I have tried:

Tried Googling but found nothing specific

Posted 26-Jan-19 5:32am

vaibhav1800

Updated 26-Jan-19 6:09am

Add a Solution

Comments

Bryian Tan 26-Jan-19 11:48am

I see there is [Image Type] column to store the image type. so what the problem? Image is image right? There should be another persona to describe it.

vaibhav1800 26-Jan-19 13:53pm

Yup True that, Just got it sorted, Thanks for your time Bryian :)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2019-01-26T06:10:00

Image type is complicated, particularly since you pass the image itself as a stream of bytes to be stored in your Image column (ref your previous question: Store image in SQL [working example for SQL server][^]) and identifying image type from the blob of data is just not really practical.

Instead, replace the Image Type column with a FileName column which includes the extension and pass that from your C# code when you save the image data. That way, when you restore it, it know what file type it should be stored in, and that should enable you identify it sufficiently.