• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Store an image input into a MySQL table row

 
Ranch Hand
Posts: 164
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to store a replacement image into a MySQL table row. I retrieve the original image and display it successfully. When I write the replacement image the write is successful. However, when I display the replacement image it does not display as an image. Therefore, I surmise that my write to the database was not correct. The prepared statement is:



The value in picture is (I have tried - replace(/^data:image\/(png|jpg|gif|jpeg);base64,/, ""):

data:image\gif;base64,R0lGODlhlgCWAPcAAAAAAAAAMwAAZgAAmQAAzAAA\wArAAArMwArZgArmQArzAAr\wBVAABVMwBVZgBVmQBVzABV\wCAAACAMwCAZgCAmQCAzACA\wCqAACqMwCqZgCqmQCqzACq\wDVAADVMwDVZgDVmQDVzADV\wD\AAD\MwD\ZgD\mQD\zAD\zMAADMAMzMAZjMAmTMAzDMA\zMrADMrMzMrZjMrmTMrzDMr\zNVADNVMzNVZjNVmTNVzDNV\zOAADOAMzOAZjOAmTOAzDOA\zOqADOqMzOqZjOqmTOqzDOq\zPVADPVMzPVZjPVmTPVzDPV\zP\ADP\MzP\ZjP\mTP\zDP\2YAAGYAM2YAZmYAmWYAzGYA\2YrAGYrM2YrZmYrmWYrzGYr\2ZVAGZVM2ZVZmZVmWZVzGZV\2aAAGaAM2aAZmaAmWaAzGaA\2aqAGaqM2aqZmaqmWaqzGaq\2bVAGbVM2bVZmbVmWbVzGbV\2b\AGb\M2b\Zmb\mWb\zGb\5kAAJkAM5kAZpkAmZkAzJkA\5krAJkrM5krZpkrmZkrzJkr\5lVAJlVM5lVZplVmZlVzJlV\5mAAJmAM5mAZpmAmZmAzJmA\5mqAJmqM5mqZpmqmZmqzJmq\5nVAJnVM5nVZpnVmZnVzJnV\5n\AJn\M5n\Zpn\mZn\zJn\8wAAMwAM8wAZswAmcwAzMwA\8wrAMwrM8wrZswrmcwrzMwr\8xVAMxVM8xVZsxVmcxVzMxV\8yAAMyAM8yAZsyAmcyAzMyA\8yqAMyqM8yqZsyqmcyqzMyq\8zVAMzVM8zVZszVmczVzMzV\8z\AMz\M8z\Zsz\mcz\zMz\8AAP8AM\8AZv8Amf8AzP8A\8rAP8rM\8rZv8rmf8rzP8r\9VAP9VM\9VZv9Vmf9VzP9V\+AAP+AM\+AZv+Amf+AzP+A\+qAP+qM\+qZv+qmf+qzP+q\VAP\VM\VZv\Vmf\VzP\V\AP\M\Zv\mf\zP\wAAAAAAAAAAAAAAACH5BAEAAPwALAAAAACWAJYAAAj\APcJHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmypMmTKFOqXMmypcuXMGPKnEmzps2bOHPq3Mmzp8+fQIMKHUq0qNGjSJMOVaZsUiZNyojpW6aUZ7QxOHLIwCEDQdevXreKyZQGatWYyjSN+bpVRtu3N9zi8CpARgwEK3CkIXZWZaYcXNsGDtwWAVfDcg8fvhtjTKa+I5WtDbv1gNu4d+Me4BrDrV2um+XK9XoAgRi+kDcum5TDK9fXnh14nn1Xxg0Ene26Db21c2AEmzNRTW1R01zYlrvG4Iz7QAznlp\LsFyasVvcc0UHFhBjEvGJmWa\+Uad3qMzslhc9Z9Gz1j3MpF3z4QAPV3hspmuG6L3m7z\rbZdt6AOICmWwNvuUfaeNM9dp9CY+z3VQyynQdfb3ahkckkixSyRSGMDDNMMoElx5hsulE33WAyBICAgw8SRExYLGJmHWOMpTHMJIwUEgaImRATpBiW4XCXkXZRx1xnEh4mRowDjSHbYvA5x11vyRnm1DAfbmEII5kko8kwaciVHFhIOuefdIj1JgAOyjxIjFaBlWfeZc3JFcNYw0jyYYeSgDKMkDhsdiYCcWEGH25VJglXi2l8p0mbYTmX23lioOEWYzlk0mchHjIiCTHDaJIJYSsu59V+iBXqmWWLEv92gHeQacKgmr7FcMNpmVin4zCMdBlikJ9IMp1\5XllXXTHtsWsiltxFQAOfU3SJrO24RbDhyFau9wkw2TSY6ieapKMtf5dl5ly2bWrooGu8makaVVlksBh5W3W2bZbcJtJeDhMcm6H\gpJ5mcHbqpspWu+xVty0IIWQ1IRonpektuCusUiYGYiRql+eliIJCJ+QuZdjC66nLorsmUZGiUyd2yR18FpVJnrSRfdhx4u4u+gGy7CsaiCjomzGGLggHSzuDnQWYXYZUcWb8fuq2xbK8hQ1KSHVS1gvz\2DOIwgooYZLjKmG1wkGMqE55hhzIpVxq94iDkbklXphwCyoL\FqlQtga2b28Z8xyGIaGGG66njPfyr+KM7yiJJOvFt\BdYxm8o45vWN5fbdLa55MylDGqWb89cyHyjxyL3CPPPIsse5cr8E0hY65O5xW4bqetTJkrOz3zfkZSCxSdhg1+Xqiwayxyl7N36KPzzxcS3dUMK52J26UO88kkyQmvt4WgB3DAT2VuemMM0X8YNvTO+0z9xtV7uNuxjF5H9+OCnp3JmeLLDsQ2NQZ98EQZW8nfcs5juNn1rHn0c98DnRfBQlBIN4xyz3RYYLcgZQINdJvEXHIjvGdFazpj2MkyaKMbBk7PS\KTn8ZkGDvZTa8Q8utSf+AzQgEGzGP\atH9\0YomCJNaz8xiIZO0sAV2VgGQRkTWQ4d2EAJWrF+GsufimCVGzEoQwwIcEoCE+ib\KWrWa6iB05sFZ8F8qsQYpDdFDcGP+g1z4E\6he7xog\y6QBjFsJD4Cs05sK4SAAejukJnBCp03pBg2MmIQkHBes6hEMh5KcXC8kuSGSOcUpmeDFJ3shCS2a52r4wx28jiSDKV2nWTSzzU0mdcq44AANgxKTiCRRPdSFSkik+gSpiJEMzRWzVMd02wBXVZsBppKZC1pOGlZ2pDOhZ5E1wYpn0CMGSYhqcp50XthEJgnGATMTmIjk5DjpwUz9cW8NM2VtmNSZuJgGjNr7itNUhv+YGKgRJHGKiHFm1hvU9SuSoawg\BhBKBz8i1Q++4PsSKYJTbmInqbEjlf2CU8ekkUG2yPSeNR0mAOkcCZLaiH0nJK2SdQPemAaBg5qN5azVdJDf1jE9jzGMoaprGoXypIMdHQ2yMmsOq95yT\3MaMJVYh9W4jpJHTEyz9ZFVQhGmh6tjcMTCyiCjcMkTJc1ahGMe2ZrgrYMHq3VhE2661GEl1KlDiQMglvX\yKaXjQQIyQ2VFjMZ2Qa+hGjL4u4g9d0ikg34O\ZzYzPg5dqy51mbtCZYkx5\OIARFSj31sdiDRYJi+PgQuTYihK2LQhDCoKMVwiZRRWdOLB8fFs8b\bjGeTGOSV8TwR66ai5j49EyhfDOdpW5EGVQJ6D46uw9oLLcgCPRaDFawBcYthm69+Kscx2Qgfo4lbX71kIryNwZYEVSeugOpp774w9Ni9ivp8QhTjOvchERoN68p5zDKO7MxhOt5NASSTOvy2PylNm2vY5gQQTjey3TlNl3JTgz2ohcSdcU1lZoXhj5CDLriBzHR2dNUDbSpHPy3fSLzFH9\mj+H7pQRdymSCNW622ly9EYenabdRIqZbN1vZnK9CFMgskKgKk2k5+UTBOMXpHjtDaNu4e0kNLXNN4RLSFuCp1C5KIYx1AZmr2zTPF1zgCd1JBpqVG5CWnk\q70H\w38jayH6pji\SKyo48tEleSdksxOGVtMg1qm7E3T8FsZVfgm9l6jDeQZXy2ImpOSBqy9xziugXORRISBR3oKSqd1zcF4kKBbJNaYggzTObKhBZBI2HSdHc6vJ1VgdyaGy2KbiomSV903kWWDU2Ng\yWZeG7aFJEAMNpoTsnk+YN+0hE5jDQDIXfXw98kQ5PH4O2GYWFJoDwEgjxk3IClH03tp8ZhKAfEsL1z0aLRNP1AU67Q1wAG8ZiAEUj9sQdNJVm0XFB1YFAuK\0EVI\5yUI2iGBnMPEo1XfSYAy+qKxzK4IOB0pTTAwYsC+yaWeEcL3ntq71g0FAMALEfD1\DzpEWJpb0IazbtpuYSmbkZOsw01n\9lwLF6S7vNib3rBJGrzh7Wc+kykTEF9O3uSmtFWlSGHnVVhy7FmQR4dEK\ChJ+ammrew9BvKsDIlIgv0mj0rjezROi3acTCGsZScuHNxNfh+KpsplelfRCJiBg8Q5JFAA+f7xg5vF5dKx0aT5YhJmtBHTe9d4WALXAkD0CVv715B\OxJWxkuyx7hwaFBhCIcBtSJ622VaAVaaoIVCO9nRrN+HSwhV3vH+SzqjpPd7KmNgQHOo7StgLJ7nebnUBXv0MJcMCxmRsmE1sTDom886lzUIty3Qnmgw7v31j97vC1\crHYu20nuxL\oh481SgTIzS5sYwt59ob00HcLXTb32lvS3EhRj8xolZ70ubdezEonf+QB3RutwIG8HPXJyQakgbTIgMI4hla8i88ZSDXEwMBEGkjQQwS9nRqIhpON0BXMkCIdAACMG9q9xqndYKzt2y0F2+aoHsrgwO7IgNThlqiN0D6QnHVsR\YYnUjQUsWRx3NBBwCoCIFJjctpoDYd1qSJ2r8pzQ3kHTaF29S2CsUGHLXxxz9hEQsl23tx1gHYIEi0VSfYyJjMGVcV3jRh1GSgDPYJ4UoaCQQd3kyEAb2tic\NxYyYHJSaG8nhB6XczUg9C9Y8VhtlhKg0IVG9kFTVU43B01Q\zaDP3d2tad9SQMDAWCJsSeFr5EJYZB0+udxXcMkzFEgGOhnNJN+EINNAgGGHNFUeSIdnREeYwAzkwBLlwZfeGNamBeJitcbJhcABgBx83aH8ZY0IqSH2ldvSEJEEXYsn5cGk6AqrWRuy1EfKLEMydNmsHIqcOZnLLcZTiEGiMQoA0d2fGaABXIel5h0cUF8W1F7YyEGwXhyRBeJ8CEbUBQWpvEvVwMxzcSKINFUQHgAzPIbo3YmKzImp3JnnlImiudneBdvwLgCB6CH5+iEfGaM4ogp8aZ0jZdz8aEpuEE3DsNvMaCKJaEPpEFIt+UcOHgshJUJpZRargWRCrl\otdmcgegAs4hhZKnfz+XBmjAk\SoiciBX0fyR3fhc90mQG4BkB8RXcqyb8dSIGNAN5NBTwJQUx5ULg+Vb6GWjgRIkTwJlLyFBkgTb+hmPh4JdHf4GaUTi2TxR7JiF+83HVDpEdgogcohY1yXN6i3jwajkIozJhUVLXAIAwdAgIs5b\DmKWvjMUJpcnbIbJznFe3BZiKENEopPIgxfnyXEm2kLRk0PBAHTTDpKf3jNkKSDB+EgmHgHJe4mLunNGiwJ0JSLpAjBgDQk\03apl3RhfSOU5HZo4ydv8q4YjvVXgHCU8\xDi6KYiIWSABQJQTWVMUuAJuQEwKKSRfZAArMH2NV3auBjpVUzzpB1kyhxIlMjNZw2XQqG8skBwa0j2mYmrhMiaulX3PwZOWeAOkcgO9GQP5xj3mIo49SXxhqXbpeRflJEL6GB8zM2EqUSZZRx1KMnCaUots95W5CTn4+QmGyQgFQodGQpsrsCsftAIAAC7RyT1ocIkrY0tDd3u59SZ8kncLVJrWWHUXyG3rRjN6IQNvMGvxCYGmdk7n5JpBJJa7B3G3CWcGAKDEAnzEFKPScYKayIePpRfIFmG\0XlV0nckwWZLySiwQlMQCJLa05rQCZ2kwlP\z0GAJTcWsZmibuNB3pObN0CnJfga+Ud2vjErnxejKuMqtVMbAVBfKRGK0LEv4IhtO6Q70\I499lpmPdHYvCEiglxu7chvbkCuOSaa8ObFHkeHgN02veOI2Qak1CpO3KUrlJPAcASk5YulnGa9gY8psQsjkEqdHNqF3l7FGiJmDgm8gilQiKsA2pyAOBQvWiC0ZIc0HhLWAFmA8RY6wlaCxcSOEOaOvMZ5jVtfBNZPEVUqdqLJqp7FOmsk\A9zooDkNMrB6CYb0egMDMGlNNstRcdRHVGEEZPu\E3A8GDIeF1GgeLG2dzmONawBEwY+JWqup\tKmOBvAx0aiH3aMM\zGKiToJAHxyKp84asbpGDhjIkC6Jy2hGJXWIkT4fCvyL4uhPUG0qctGgeC5K72JS0+4k\emOLxZrMUaADVVgqLGBZhRZuHhr+mpL+fpEpMANfezTIzlKs53RpE1jHkzb0Q5FjvpUDgAnp+qkM6hkx57A7HKqowXSKLhTFkCMYy2EkWmLZbikgDyMplQXnwZGmwnQkyItCcKsv9Cmb3CkxCHCR5krOuoe0QbUmf3lkOlKafSG6y2G8ojV+E2EirZRE\WKFslA5gwBi7SWEkIg4\LGYI7DG\nFCWHS4QpoHNar435Z5jQcUwoA4UKPmvYjFXDHaQBE1rRQkDYLMtBOf\ohiH+mHbouCvnsZjeJlMm5ykHQKVoE42z6bEeWXSaCEibB1JpUk1VMyswoQxHpByIZB0IkgYOmQYYJ7D7QXk2C3LAuCfK0IkE2ithMCaCggaw+4uYuHu8R3b5B1LRiACOsV\jmiIr84UxoQkT+B+NgriTOwm1u0Vm97iZR7G8RzeWOCrnwT3K8ITsuns7SZvvd4LDaCSOkXeCY4vREQC0EhNuQW5LeVt5g27FF00dF3LtWCjxWk7mIwbJsBx6ypvW+XayS6enC5jhCB\tQXHpl5cocasxZh6pF5IflXmW8SY4QIcruKkywJMUaYxhYHJvEANhICQ3cAOVZnLgWa\AUCnvxgXXpwJu4IGokokVSgdsCS+MxENT+MfFNkwmDNNmbKY1IkrdYtX57F7lLkrFRkDPIkGeFydJUyRiinHzQsD\emz\3KvzcuTjqImtVoTmnBnJ+qy77EnS0uBfCLJl7yYMODG5kOW9GGJ4PkclxieJEynb0yUJSzGb\wcJldObRwD9lqa04EGN1EgHVjD6RIwQUuFdtybs8mTl2wARPm\mLyOwVjC2OvGSDzC68jJiBwGdOq8DRMdOHFf7pF6brbGMVBO\oeWjcyYp6qTbzebdDqbaKyTREnCVUiZznoDkxCbmKiY9uocokwdLLAVAfBtNdFETDKf4SqbojoJ\zcwcPMctHEstkNrrCgKx\cbtNk8lgAMx\FIr8+BiRCnkxiEWdtKEAarEuR7P7dxvtDhpxQYBpJAHx7Tm4opzEgM0vWKyWOxhjCQz\fMrgQd1EgDAEvtHPZahSPELDN9E5QQGlUiHZ5aabX50yrgBrxp0G8n0LvsvNjMkxpNoOxqr2+Mic4hCah6A2lwLkIbzE6UqKSRfARBDx4WEzggfu5RaUNbp1iKlmhLJJSjApc4oLsntgR4iZ+EdIrprPe8e5OMBiAbbTGgITq5Aoo5tU83Ol7RgGiKMZXmHLGpAmlAzxebBmW5qSW3uLuHNCraVXuClh\rp1g6DE\IiQPa0v8EeUrLEgNSPBOZUBcMaJeGLaOUOZvgoseYoCtTRnJ7Is5OoSFFK5NexNkrMHK6kgllmQmCK6NvxzDnC9ESLROZW1dC1RWJatjFupiUbHKZsidi7X811ad0EwbdEQZudyoxgAnEMN5hMGV5vJNtzcbIDHEhBsVldhOBfRD8dTvGbdi718+o2uHg\EeSR6A7oiGUQzk74msGzdlu7dbetgXOW4Uqwh3R4So38d4GUV4Ia9xJt9rIbNDRW8KoSiQq0NEbHS44IAkfw9Ldwalp0IkkLgkQJ9I7BIvTsQLJvRIVjhBgdCT9kXTQMeSYOCAdfQCSMG9ddZtfTqDodiofNOT\u8fb84wDQ85bLgjhjrU3K9DeBatUDjFp7lvFi5zEtYl3cR6ei9m8BJopycAInxfabudQiN7Luzehvuseej4UF14hdgGLL\7V6N266IbMBzDMQDQWkLzUt\3JvSnMg+y5wisDVy63EqGA9\h1u4bMYu6ppxoGMDOW7Grdn23ScwrA4dnJFOlkBzCfaxLRkHF+EnrcjDG\kk6BO+mC9fp2G\J5VGhy9krLcj21yu5mScQQWY4SNY0fh0RQBLXI4cnJQlvnMJ4pkvR5fTrtEB5xgzyB9EGwCmHjNVHTrzVIpQkdzkHCi6vQUV62nfx2YX7Ft9XlXgQl+9CCCrQYBIXo\6K9yXFozqcK4Ue8b6ucJ+F76fdxSGnYuWOmy8cMziW30IyV2qd5KXcBcWR6EOeOEgqnEexblbmC8lm36aeU7xbydGfKkrrsUBKvEAeOALr67C8JcAvkklnj6lhtuXgRMETRrceVBkN4xWnlSM0UAwKwsC0Z080RADcQ6zZRX2r\EF+kO3fb3CxH9Cqy3v1htyY1DElfEdFgveF6Kf2UO6tM2tRBkUTb9gOB+CKh9SKhDFrBlqXZb\ymMIgeh7yl+Dpx8xwGPPRR3I8q8o8qgkqH+Xt+E8OhEssQFam6KWzZ+YMcMMrg7w6h+Xv\EOgGFVNF+kNB+7X\Eozf+8Af\Dx8L\w3oQ+\fxa8T\zKv\xDUQ+MyvwwkfPQP\3UX\3Wf\3YfxLHn\3c\x3P3\3gH\7iP\40Yfzkf\43ERAAOw==
 
Saloon Keeper
Posts: 10687
85
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is the SQL type for column 8?

I would think that an image stored in a database would be a BLOB (binary large object).
 
Glyndwr Bartlett
Ranch Hand
Posts: 164
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The SQL (MySQL) type is mediumblob and the input is string. I guess what you are telling me is that I need to convert string to mediumblob (I have read that string can be stored in blob) how do I do the conversion please?

I tried:

 
Rancher
Posts: 662
10
Android Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Perhaps you can convert string to inputStream , then use setBlob.

 
Glyndwr Bartlett
Ranch Hand
Posts: 164
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry, that did not work.



Do you know if I need to do this:



or is it fine to have "data:image/gif;base64," at the start of the string?
 
Randy Tong
Rancher
Posts: 662
10
Android Tomcat Server Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Where you get the replacement image ?
 
Glyndwr Bartlett
Ranch Hand
Posts: 164
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Front end is HTML5, bootstrap, javascript and jQuery to Ajaxa into JSON to java client side to java server side to MySQL.
 
Carey Brown
Saloon Keeper
Posts: 10687
85
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The image you've posted is not binary it is a base64 encoding of binary.
 
Glyndwr Bartlett
Ranch Hand
Posts: 164
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Do you have a solution please? I have searched on base64 observation and tried:



This does not work either.
 
Carey Brown
Saloon Keeper
Posts: 10687
85
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What data type is "picture" and what does it contain?
 
Carey Brown
Saloon Keeper
Posts: 10687
85
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If it is binary data then there's no such thing as "UTF-8" with regards to it.

How are you reading the one that works?
 
Glyndwr Bartlett
Ranch Hand
Posts: 164
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Sorry I do not understand your question. In my original post I have the contents of the String. So I suppose the answer is I pass a string with the data above. I have seen where one solution that removed the starting characters as per my posts above. I do not know if that is required?

Kind regards,

Glyn
 
Carey Brown
Saloon Keeper
Posts: 10687
85
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Do you understand:
  • Binary data vs character data
  • BLOBs
  • Image file formats
  • Base64 encoding and decoding


  • You seem to indicate that you can read an existing image from the database. How are you doing that?

    You are giving us very little to go on.
     
    Glyndwr Bartlett
    Ranch Hand
    Posts: 164
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    I very much appreciate your help Carey.

    I read the data in from MySQL with:







    Kind regards,

    Glyn
     
    Carey Brown
    Saloon Keeper
    Posts: 10687
    85
    Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    Glyndwr Bartlett wrote:The SQL (MySQL) type is mediumblob and the input is string. I guess what you are telling me is that I need to convert string to mediumblob (I have read that string can be stored in blob) how do I do the conversion please?

    I tried:


    A BLOB is not for String data it is for binary data.  Why is your input a String?
     
    Glyndwr Bartlett
    Ranch Hand
    Posts: 164
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Hi Carey,

    Sorry I am not a programmer. I am doing this to provide a system for recording and reporting on awards for my Scouts. I am learning as I go and doing lots of research. I see that I need to convert my base64 string; however, this is what I am struggling with. I can not find the right code.

    Kind regards,

    Glyn
     
    Glyndwr Bartlett
    Ranch Hand
    Posts: 164
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Hi Carey,

    My input is a string because that is what is passed from my input. I use HTML, bootstrap, javascript, jQuery to get the input. I then use ajax and JSON to pass the input to the client side java and then to the server side java to store. The HTML, bootstrap, javascript, jQuery is getting the image and displaying it on the page. That took a few weeks. Now I am passing the image data to be stored.

    Kind regards,

    Glyn
     
    Carey Brown
    Saloon Keeper
    Posts: 10687
    85
    Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
    • Likes 1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    This is how you are reading the image so you'll have to reverse these steps. Note that "imageDataString" may represent an image it is no longer an image, ie binary data, it's a String. So, if you were to be given an "imageDataString" to put into the database, you'd have to strip off "data:image/jpeg;base64," using substring(). Then you'd have to call decodeImage() (whatever that is?) to convert it to a byte[]. Then you'd have to use ps.setBytes​(long pos, byte[] bytes) to write out the binary data to the BLOB.
     
    Carey Brown
    Saloon Keeper
    Posts: 10687
    85
    Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
    • Likes 1
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Correction:
     
    Glyndwr Bartlett
    Ranch Hand
    Posts: 164
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    I found this: https://javapointers.com/tutorial/java-convert-image-to-base64-string-and-base64-to-image/

    This, and your response answers my earlier question about removing the start with"



    So now I will use this in future.

    So the code is:

                                   

    This can be simplified to:

                                 

    This does not work either. I will continue to investigate.

    Kind regards,

    Glyn
     
    Glyndwr Bartlett
    Ranch Hand
    Posts: 164
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Carey,

    Thank you so much for your help! The answer is:

    As you said:



    This is done before passing to java client side. Then on the server side:



    Once again thank you very, very much.

    Kind regards,

    Glyn


     
    Carey Brown
    Saloon Keeper
    Posts: 10687
    85
    Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    I find it useful to have a utility class to encapsulate these steps. Then call the static methods from your project. Something like
     
    Consider Paul's rocket mass heater.
    reply
      Bookmark Topic Watch Topic
    • New Topic