Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Interesting...
Ha Ha Nuno !!
Interesting message. But it seems the reply was given by some idiot who does not know what a table/database is
I dont think SS works that way !!!.
nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote in message news:<3b64017a.1970106_at_news>...
> 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 Mon Jul 30 2001 - 06:11:27 CDT