From: Michelle Murrain <tech@murrain.net>
To: Wei Weng <wweng@kencast.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: text vs varchar
Date: 18 Jun 2002 19:31:46 -0400
Message-ID: <1024443106.15580.380.camel@brown.ursa-minor.com> (raw)
In-Reply-To: <1024438061.16895.2.camel@Monet>
References: <1024438061.16895.2.camel@Monet>
On Tue, 2002-06-18 at 18:07, Wei Weng wrote:
> Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR
> datatype with a maximum length, especially when I do searches on them?
There is one big disadvantage that I've found, but might be utterly
unimportant to you. Some applications (particularly Crystal Reports) do
not like unbounded text fields, and make it quite difficult to do any
manipulations of them. This might be an odbc issue, rather than an
application issue, but it can be a big deal sometimes.
--
.Michelle
------------------------------
Michelle Murrain, Technology Consulting
tech@murrain.net http://www.murrain.net
413-253-2874
413-222-6350 cell
413-825-0288 fax
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tech@murrain.net, wweng@kencast.com
Subject: Re: text vs varchar
In-Reply-To: <1024443106.15580.380.camel@brown.ursa-minor.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox