On Thursday 16 March 2006 15:33, Joost van der Sluis wrote:
> > > I've changed PQConnection so that a text field is also interpreted as a
> > > varchar. But I don't agree that you can use this or a varchar like a
> > > BLOB-field. It's true that they are unlimited, (up to 1 GB) but the
> > > problem is that they are handled like a normal field. Thus if you do a
> > > request for a record, the field is send in that request.
> > >
> > > Normally, a BLOB-field is not send with the record, but only if you
> > > specially ask for the data in the blob.
> > >
> > > SQLDB always buffers all the records. Thus if you have a unlimited
> > > varchar, sqldb will allocate approximate 2000 (the max) bytes for this
> > > field for every record. Keep that in mind while you're designing your
> > > database.
> >
> > So I can not use a varchar c(8000). If the limit is 2000 bytes then I
> > can only have 1000 chars. Is that correct?
>
> No, I thought that limit is 2000 chars. But I was wrong again. The max
> amount of characters is defined as dsMaxStringSize = 8192
I think I can get away with 8192 chars. But of course a postgres text data
type will hold the size of the HD.
BTW thanks for the help.
John
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
