On 4 Apr 2006 04:15:06 GMT, Patrick TJ McPhee <ptjm@xxxxxxxxxxxx> 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. Yeah - and LOBs are a royal pain too. Lucky we mostly deal with numbers here ;)