Re: Saving img to mySQL
Posted: Sun Oct 17, 2021 4:35 pm
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
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