Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Interesting...

Re: Interesting...

From: jock <jockey_sql_at_indya.com>
Date: 30 Jul 2001 04:11:27 -0700
Message-ID: <77a43c6a.0107300311.492c8339@posting.google.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US