Re: SQL Humor
Date: 19 Aug 2005 11:25:01 -0700
> Once you start dealing with text of length > 4000 (Unicode) 8000 (ANSI),
> you are practically working with documents not attributes, so this data
> should be stored in a document management system with numeric or URL
> pointers stored in the relational database. The TEXT datatype is there for
> large blobs of data for those so inclined, but it's an entirely different
> case usage than VarChar.
> On the application side, if you are storing gigabytes or even 10s
> megabytes of data in a string or array, then it is time to start
> re-considering the application design.
Remarkable. You suggest that arbitrary limitations on datatype length provide invaluable insight on application design weakness? So if my app processes 1GB strings all over the places (think XML!), I'm fine, but if I get 3GB string, then I should redesign my application? Received on Fri Aug 19 2005 - 20:25:01 CEST