Request a Demo
Home   >   mailing lists

Re: PSQL Data Type: text vs. varchar(n) - Mailing list pgsql-general

From Jeffrey Melloy
Subject Re: PSQL Data Type: text vs. varchar(n)
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: PSQL Data Type: text vs. varchar(n)  ([email protected] (Patrick TJ McPhee))
List pgsql-general
Tree view 
Patrick TJ McPhee wrote:

>In article <[email protected]>,
>Jim Nasby <[email protected]> wrote:
>
>% 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.
>
>Sybase: 254. Silently truncates.
>
>
>
IIRC, Oracle is 4096.

Jeff

pgsql-general by date:

Previous
From: "Jonas F. Henriksen"
Date:
Subject: Re: full join question...
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Creating an index on PostgreSQL 7.4.3