Confused about storing arrays in a custom property

Bob Sneidar bobs at twft.com
Tue Aug 23 16:54:24 EDT 2011


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





More information about the use-livecode mailing list