> > 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 -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives