Image in database

Question

0.00/5 (No votes)

See more:

In oracle 11g no problem in storing image in database.
But what about sql server 2005 and 2008?
Not take big size or take original size?

Posted 11-Sep-10 13:03pm

Mostafa Elsadany

Updated 11-Sep-10 20:48pm

Abhinav S

v2

Add a Solution

4 solutions

Solution 3

You could also check here[^].

Posted 11-Sep-10 20:47pm

Abhinav S

Solution 2

thank you mr.
but can you tell me
what is the type using to storing image in sql server
i convert image to byte[] in c#
thank for help

Posted 11-Sep-10 18:59pm

Mostafa Elsadany

Comments

TheyCallMeMrJames 12-Sep-10 1:46am

I can, but that's not what you asked originally. Here's the first in a series of articles that teach about images in SQL Server: http://www.databasejournal.com/features/mssql/article.php/3719221/Storing-Images-and-BLOB-files-in-SQL-Server.htm

Sandeep Mewara 12-Sep-10 2:08am

Not an answer, should have been a comment to the answer. Use 'Add Comment' feature to respond to an answer. You can also use 'Imporve Question' in order to edit/update your question.

Solution 4

You can store image directly to the database, but as alternative, you can store image in physical drive and save the image path on DB. And while showing based on the image path from DB show it from Physical drive. But yes, this depends on your requirements.

Posted 12-Sep-10 3:07am

Abhijit Jana

Comments

Mostafa Elsadany 12-Sep-10 16:17pm

thank mr.
but this depends on requirements or hardware or security ?
and if store image in database sql server 2005/2008 this image take big size or orginal size ?

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)

TheyCallMeMrJames · Accepted Answer · 2010-09-11T18:30:00

Solution 1

There is no problem storing images or other blobs in SQL Server 2005/2008.

The size of the image in the database will be determined by the size of the image you store: it will be the same size.

Cheers.

Posted 11-Sep-10 18:30pm

TheyCallMeMrJames

Comments

Mostafa Elsadany 12-Sep-10 16:13pm

thank you mr.
but What is the best type to store the image in sql server