Does images will be compressed while storing in database

[rubobby]

Hi all! I had a doubt :zzz: , Does images will be compressed while storing images in to the database? iam using file upload control to upload the images into the database. while uploading iam converting the image into byte streem. AND ALSO TELL ME WHAT IS THE COMPRESSION RATIO(IF COMPRESSED). AND TELL ME WHAT IS THE DEFAULT IMAGE SIZE IN SQL SERVER? PLEASE GIVE ME THE INFORMATION.

raj

[eyeseetee]

If I were you, I would store the file location of the images rather then the actual images in the datavbase. You will very quickly find that your database size balloons. Im not sure if it compresses them, my guess is they wont compress

We are not a Code Charity

[Ashfield]

.netman wrote:

If I were you, I would store the file location of the images rather then the actual images in the datavbase

Definately the best way. Also saves the work of getting them back out of the database and displaying them.

Bob Ashfield Consultants Ltd

[SteveNY]

No they don't. You would have to run your own compression method on the byte stream before stored into the db and reverse for retrieving them.

[Guffa]

rubobby wrote:

Does images will be compressed while storing images in to the database?

The data that you store in the database will not be compressed, but for most common image formats (like jpeg, gif and png) the data is already compressed so you don't need any further compression.

rubobby wrote:

PLEASE GIVE ME THE INFORMATION.

Stop screaming.

Despite everything, the person most likely to be fooling you next is yourself.