On 3/16/06, Joost van der Sluis <[EMAIL PROTECTED]> wrote:
> On Wed, 2006-03-15 at 08:13 -0500, Alexandre Leclerc wrote:
> > On 3/15/06, Joost van der Sluis <[EMAIL PROTECTED]> wrote:
> > > A varchar can hold 2000 characters in sqldb. Postgres supports up to
> > > 8192 characters in a varchar. If you really need 8192 characters, it's
> > > easy to update sqldb, just set this value on top of db.pp.
>
> Normally, a BLOB-field is not send with the record, but only if you
> specially ask for the data in the blob.
Indeed, the whole text will be sent... (which I found great: but also
it make you think wisely before sending a SQL request or when
designing a Db with that type... should there be a limit, and of which
size... and when to use it).
My memory is failling me on this, but I think there was a way to tell
the DB to only return a part of the field... I can't recall clearly...
So you would avoid getting a, let say, 1 Gb string. :)
Best regards.
--
Alexandre Leclerc
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
