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
Saving img to mySQL
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Saving img to mySQL
- Attachments
-
- sqliteblob.zip
- (14.69 KiB) Downloaded 76 times
-
- Posts: 641
- Joined: Tue Jul 29, 2014 12:52 am
- Location: Brazil
Re: Saving img to mySQL
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
But again many thanks again for your suggestion.
Regards
Simon
________________________________________
To ";" or not to ";" that is the question
________________________________________
To ";" or not to ";" that is the question