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 <janschen...@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 <p...@mollysrevenge.com> >> To: How to use LiveCode <use-livecode@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
