Probably something similar to what I encountered when passing an AES encrypted string that *might* contain commas or characters that would jack a query. Using sqlYoga solved that for me as the insert and update queries are escaped by default (correct me if I am wrong).
Bob On Dec 21, 2011, at 1:22 PM, Pete wrote: > The problem I had was that it just didn't work using a blob. The encoded > array got stored OK but LC didn't recognise what came back as an array, > don't remember all the details. > > The default max size of a text field in SQLite is 1 million characters so I > think he'd be pretty safe. > > On Wed, Dec 21, 2011 at 12:48 PM, Bob Sneidar <[email protected]> wrote: > >> How can you tell how big the encoded array will be? I would use blobs >> whenever the size might increase in the future beyond what I expected. But >> if the array is a fixed size, and you know for certain it will never grow >> beyond x, then a text column would do fine. >> >> Bob >> >> >> On Dec 21, 2011, at 10:35 AM, Pete wrote: >> >>> One thing I mentioned earlier that might be relevant to him is that >> there's >>> no need to use blobs when storing LC arrays. Just use base64 encoding and >>> store it in a text field, works fine. Some folks on this list pointed me >>> in that direction a few months back. >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> > > > -- > Pete > Molly's Revenge <http://www.mollysrevenge.com> > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
