<div>
Are you using ADO or what database provider?<br />
<br />
John
</div>


Are you using ADO or what database provider?

John

<div>
I am using myComponents by AidAim
</div>


<div>
Thanks, that gave me enough clues to get it working.
</div>


Thanks, that gave me enough clues to get it working.

<div>
<div class="content wysiwyg-content">
I want to save a screenshot into a mySQL table using Delphi code.<br />
<br />
I have the jpeg image in a TImage component and want to write it using an SQL statement into a LONGBLOB field. I also want to be able to load it back from the db into an Image component.<br />
<br />
I do not want to save the file locally and reference it via a field in the DB (I know many recommend this option)<br />
<br />
Thanks.<br />
<br />

</div>
</div>


I want to save a screenshot into a mySQL table using Delphi code.

I have the jpeg image in a TImage component and want to write it using an SQL statement into a LONGBLOB field. I also want to be able to load it back from the db into an Image component.

I do not want to save the file locally and reference it via a field in the DB (I know many recommend this option)

Thanks.



Saving JPEG image into LONGBLOB field in mySQL

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.