Database syntax

[Pete]

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 <bobs at twft.com> 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
> use-livecode at lists.runrev.com
> 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>