Database syntax

Bob Sneidar bobs at
Wed Dec 21 14:48:38 CST 2011

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. 


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.

More information about the use-livecode mailing list