On Tue, 2006-03-14 at 14:26 -0800, johnf wrote: > Unfortunately the lack of blob support is a deal breaker for me. I need to > have the use of TDBMemo. The app I need to write requires notes in many > locations. I.e. I need notes on customers, notes on Vendors, Notes on > inventory, etc.. Unless someone can provide a work around I'm stuck. I > considered use a 254 Varchar but that won't work because some of the current > data has 800+ chars. In postgres I actually need data type 'Text' (same as > blob with a different name. But I wonder why postgres has Text and blob.) > > So guys what can I do????
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. Using memo fields too much, is a design-fault, imho. They should only be used for images, complete documents and such. -- 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
