On 4 Apr 2006 04:15:06 GMT, Patrick TJ McPhee <[EMAIL PROTECTED]> 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 tr
tends to have worse sql embedded in it. Again I would point to my
previous suggestion of containing db access in a small set of
classes/methods/whatever - then you can assign your most sql savvy
developer to maintaining that code.
Just my 2c.
Mark Aufflick.
--
Mark Aufflic
I'm not aware of one, but I would also be very interested.
Certainly Postgres is much more standards compliant. In terms of
developer features, Postgres is also much more advanced. Sybase also
has some unusual limitations in wierd areas like the maximum number of
bytes of index per row.
Sybase wo
To go slightly OT, I have the current displeasure of becomming
acquainted with Sybase which has ideas about being flexible with
standards (and sanity) much like MySQL.
The first of the two intentional "helpful" features I have come across
so far is that inserting (or updating) char/varchar columns