Interesting...

I'm sure another case of the much better product striking again...

This was in one of my local newsgroups:

>In the first place you shouldn't be doing this.
>In the second place you shouldn't be doing this on a database. Definitely
>not.
>You should always put text fields at the end of each row. Often they are
>long and are not searched on or used for RI. Variable length text fields
>should always go on the end of each row 'cos they are a nuisance for
>efficiency. You don't want to have to find the end of the variable length
>text fields or scan across long fixed length text fields to get to the
>fields you will need often.
>BUT, as to putting a 2million character text "column" on a database, well
>just forget about it. That's not what they're for.
>><snipped>wrote in message
>> I want to create a table with a text data type column that is 2,000,000
>> characters in length..
>> How do I do this? It seems 8,000 characters is the max allowed for some
>> reason?

 Am running MS SQL Server..
>>

Nice eh? Next time we hear about SS being such a good database, well...

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sun Jul 29 2001 - 07:39:45 CDT