I gave up from using ODBC... to much problems with blobs and other stuff...
and really very low speed under Delphi. Try Zeos Database Components for
Postgre(http://www.marms.com/zeos). I've been using for 6 mounths and its
great. Blobs greater than 8Kb still are a big problem, but you will see this
component can recognize text fields as Memo and OIDs as Binary Blobs.
A really good point of these components is that you dont need BDE or ODBC
(everything is done accessing a single dll). My apps are very small and
installation is a piece of cake.
My config : Zeos 3.0.8 under Delphi 5 Enterprise.
José Vilson de Mello de Farias
Dígitro Tecnologia Ltda - Brazil
----- Original Message -----
From: Paolo Sinigaglia <sini(at)informativesystem(dot)it>
Sent: Quinta-feira, 29 de Março de 2001 11:53
Subject: [GENERAL] VARCHAR and TEXT
: Hi everybody,
: I have a little question about string types in PostgreSQL: it seems I
: understood well how string data are stored in the database, from a recent
: post by Tom Lane I feel encouraged to think that VARCHAR and TEXT are
: treated the same way by PG, i.e. they occupy ony the space needed by their
: actual length, bt I'm not so sure of it.
: I ask this because I'm trying using PG as database server in a project
: developed in delphi under ms-win and it seems to me that varchar and text
: fields are not treated the same way by odbc interface and/or bde (borland
: database engine, the database interface layer used by delphi programs).
: I connect to a table the fields of type VARCHAR are seen as strings while
: the fields of type TEXT are seen as blobs, and this is a little upsetting,
: because some useful functions are not implemented for blob fields.
: I have several tables with fields that could contain quite lengthy
: but usually don't. So I don't want to define theese fields as VARCHAR(400)
: if this means a disk occupation of 400 bye or so for each row (I have some
: 500000 rows in a table and the average length of the field in question is
: about 30, but the max length is near 400).
: Can someone clarify this point?
: Thanks in advance
: ---------------------------(end of broadcast)---------------------------
: TIP 3: if posting/reading through Usenet, please send an appropriate
: subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
: message can get through to the mailing list cleanly
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2001-03-29 17:00:35|
|Subject: Re: Pgsql-7.1RC1: SET SEED = <something> |
|Previous:||From: Tom Lane||Date: 2001-03-29 16:43:43|
|Subject: Re: [SQL] inconsistent functionality with LIKE operator |