Help me to convert Image data type as html content

• panneermca35

  Mr or Mrs. 500

  Points: 504

  More actions

  June 29, 2016 at 3:32 am

  #308744

  Dear All,

  I have saved image as image datatype in database now i want to convert that image as HTML content using sql query. Kindly give me the suggestions.

• Phil Parkin

  SSC Guru

  Points: 247155

  More actions

  June 29, 2016 at 5:06 am

  #1887566

  panneermca35 (6/29/2016)

  ---

  Dear All,

  I have saved image as image datatype in database now i want to convert that image as HTML content using sql query. Kindly give me the suggestions.

  Can you provide more detail?

  Images cannot be converted to HTML, so I am wondering what you mean.

  ---

• GSquared

  SSC Guru

  Points: 260824

  More actions

  June 29, 2016 at 7:16 am

  #1887613

  Image is a binary datatype. HTML is text.

  Do you mean you have an image (a jpg, png, bmp, or similar) file stored as "image" datatype (binary), and you want to pull that into an HTML website?

  Or do you mean that some HTML was stored in an image datatype column, as binary data, and now you need to convert it back to HTML (text)?

  Or something else?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• panneermca35

  Mr or Mrs. 500

  Points: 504

  More actions

  June 30, 2016 at 1:03 am

  #1887782

  Hi,

  I have stored image as binary data type and i want to generate as html content for report purpose.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  June 30, 2016 at 10:26 pm

  #1887995

  panneermca35 (6/30/2016)

  ---

  Hi,

  I have stored image as binary data type and i want to generate as html content for report purpose.

  This task has nothing to do with SQL.

  You need an OCR application.

  _____________
  Code for TallyGenerator