Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (4k points)

We are developing an E-commerce website using Asp.net and Sql server. The customer can view and order a wide variety of switches and light fittings.

As we need to display images of these products for each category, the number of images we need display may rise to over 500. We are bit confused by whether we should save these images as Image type in SQL, or whether it's better to store the path of the image. In the latter case, is storing all images under single folder better?

Please advise on the best course of action.

1 Answer

0 votes
by (8.7k points)

You get confused that may be the image datatype in SQL could be used but this not the case, for storing we have another datatype which very efficient in storing the BLOB(Binary Large object):

varbinary(max)

 Variable sizes and limit of objects stored are up to 2 GB(gigabytes).

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
2 answers
asked Sep 9, 2019 in SQL by Sammy (47.6k points)
0 votes
1 answer

Browse Categories

...