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

[Jeffrey Melloy <jmelloy@xxxxxxxxxxxxxxxxxxxx>]

Patrick TJ McPhee wrote:

> In article <129CC42D-26B3-4426-8A0A-B1117465F1A8@xxxxxxxxxxxxx>,
> Jim Nasby <jnasby@xxxxxxxxxxxxx> 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