How to store jpeg images in database

  • i want store images in to ms-sql server database what is procedure...

  • Take a look at this FAQ:

    http://www.sqlteam.com/item.asp?ItemID=986

    /rockmoose


    You must unlearn what You have learnt

  • Just don't do it - you'll give yourself heaps of work, ruin your app performance, and I can only think of ONE business case where you'd need to do this, and I'll bet you're not doing it.

    Save the jpg to a folder, and store a reference to it - you'll thank me

  • What is the ONE business case you are thinking of ?

    Curious.

    /rockmoose


    You must unlearn what You have learnt

  • in the event you're building a configuration management system where you may need to 'prove' an audit trail on some code or pictures in some way.  And it took a lot of thinking of, I can assure you 😉

  • Nice, thank You sqluser.

    A source control system could probably accomplish the same thing.

    /rockmoose


    You must unlearn what You have learnt

  • Certainly could, depending on the system.  I was thinking in terms of when you're trying to write the class of tools that could include a source control system!

    But yeah, not something you'd want to do every day...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply