Confused about storing arrays in a custom property

Pete pete at mollysrevenge.com
Tue Aug 23 18:15:51 EDT 2011


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 <bobs at 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 <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
>
>
> _______________________________________________
> 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