Confused about storing arrays in a custom property

Bob Sneidar bobs at twft.com
Tue Aug 23 17:28:54 EDT 2011


Oh right. I should read up before one hand typing something. :-) 

Bob


On Aug 23, 2011, at 2:20 PM, Pete wrote:

> Turns out there's an sqlite parameter that controls the max length
> (SQLITE_MAX_LENGTH) - its default is 1 billion so I think I'm safe storing
> encoded array information!
> 
> You might be thinking of the mySQL CHAR data type size limit which is 255.
> 
> Pete
> Molly's Revenge <http://www.mollysrevenge.com>
> 
> 
> 
> 
> On Tue, Aug 23, 2011 at 1:54 PM, Bob Sneidar <bobs at twft.com> wrote:
> 
>> 255 if i am not mistaken. Larger and you need to use blobs
>> 
>> bob
>> 
>> On Aug 23, 2011, at 12:46 PM, Pete wrote:
>> 
>>> Good point Jan, I will check on the max size of a TEXT column in sqlite
>>> Pete
>>> Molly's Revenge <http://www.mollysrevenge.com>
>>> 
>>> 
>>> 
>>> 
>>> On Tue, Aug 23, 2011 at 12:22 PM, Jan Schenkel <janschenkel at yahoo.com
>>> wrote:
>>> 
>>>> Glad it helped - as for storing in a CLOB, that's just the database I
>> use
>>>> at the day-job, which makes a distinction between CLOB and BLOB for
>> schema
>>>> definition :-)
>>>> It always depends on the size of the data, and some RDBMS's can be a bit
>>>> fussy about the data definition and the supported size.
>>>> 
>>>> Jan Schenkel.
>>>> =====
>>>> Quartam Reports & PDF Library for LiveCode
>>>> www.quartam.com
>>>> 
>>>> 
>>>> =====
>>>> "As we grow older, we grow both wiser and more foolish at the same
>> time."
>>>> (La Rochefoucauld)
>>>> 
>>>> 
>>>> ----- Original Message -----
>>>> From: Pete <pete at mollysrevenge.com>
>>>> To: How to use LiveCode <use-livecode at lists.runrev.com>
>>>> Cc:
>>>> Sent: Monday, August 22, 2011 11:30 PM
>>>> Subject: Re: Confused about storing arrays in a custom property
>>>> 
>>>> Hi Jan,
>>>> The base64Encode worked great, thanks for the tip!  I didn't need to
>> store
>>>> it as a CLOB type actually, just as regular text.
>>>> Pete
>>>> Molly's Revenge <http://www.mollysrevenge.com>
>>>> 
>>>> 
>>>> _______________________________________________
>>>> 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
>>>> 
>>>> 
>>> _______________________________________________
>>> 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
>> 
>> 
>> _______________________________________________
>> 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
>> 
>> 
> _______________________________________________
> 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





More information about the use-livecode mailing list