Re: text vs varchar

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