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 <[email protected]> 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 <[email protected] >>> 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 <[email protected]> >>>> To: How to use LiveCode <[email protected]> >>>> 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 >>>> [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 >> >> >> _______________________________________________ >> 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 _______________________________________________ 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
