Page 2 of 2

Re: Saving img to mySQL

Posted: Sun Oct 17, 2021 4:35 pm
by terryho
Hi

Attach simple is for your reference.

Please create a temp folder in c:, like "c:\temp"

Which the livecode script will read the table and image file in "c:temp"

The save blob in sqlite is some different with mysql or odbc, so there is 2 method to insert blob data in sqlite db

I think in mysql will need base64encode to storage blob field, but in my case I don't need base64encode to storage blob in firebird db.

Please try the sample and test it, which work in my machine.

Regards

Terry Ho

Re: Saving img to mySQL

Posted: Sun Oct 17, 2021 4:41 pm
by simon.schvartzman
Thanks Terry, actually my issue is not how to insert the data on the table (that was already answered with the help of Elanor in a previous post). I was wrong about the possibility of recovering the image just by downloading from the DB without any further manipulation. I concluded this is not possible and therefore I dropped the project.

But again many thanks again for your suggestion.

Regards