Re: PSQL Data Type: text vs. varchar(n)

On Mar 31, 2006, at 12:51 AM, Tom Lane wrote:
> Well, if you are looking for the lowest-common-denominator textual
> column datatype, then varchar(255) is probably it ... I think even
> Bill
> Gates would feel ashamed to sell a database that could not handle
> that.
> But my reading of the OP's question was about whether there's a
> usefully
> large value of N for which every available DB will take "varchar(N)".
> I'm not real sure what the practical limit of N is in that question,
> other than being pretty confident that Postgres isn't holding down
> last place.  Comments anyone?

Not sure if it's still true, but DB2 used to limit varchar to 255. I
don't think anyone limits it lower than that.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461