Javascript Array save into mySQL Database as BLOB (MIME TEXT not IMAGE)!

Question

I was looking for an example how to store a large text array ( javascript ) into my mySQL Database as BLOB.

I don´t know which solution works:

Javascript array will be send via Ajax JSON then processed via the PHP File. Convert JSON -> BLOB and save into mySQL Database. Fetching BLOB convert to JSON send to javascript variable.

Create a BLOB with arraydata and send a BLOB file via Ajax ( possible? ) and store it in the database. Fetching Blob via Ajax converting it in javascript back to an array.

It would really help me if somehow has some tutorials regarding this question. I have seen some rough examples for saving images (MIME: Type PNG etc) but not MIME: Type Text.

Thank you !

zer02 · Accepted Answer · 2012-07-03 09:43:58Z

-1

Already solved it. Question closed.

I just base64_encoded and base64_decoded the variable as usual. You just had to assure that in the my.ini (mySQL) max_packet size was set larger than 1MB in order to save the file, that was the reason it was not working.

edited Jul 3, 2012 at 9:43

answered Jul 2, 2012 at 12:29

zer02

4,0214 gold badges34 silver badges68 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Javascript Array save into mySQL Database as BLOB (MIME TEXT not IMAGE)!

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related