No problem Bob, I'm learning fast that there are a LOT of variations between SQL DB types! Pete Molly's Revenge <http://www.mollysrevenge.com>
On Tue, Aug 23, 2011 at 2:28 PM, Bob Sneidar <b...@twft.com> wrote: > 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 <b...@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 <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 > >> > >> > > _______________________________________________ > > 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