Re: 4096 text column?

Kevin,

Thanks so much for your prompt reply. So, I can use a long and stick textual information in it but be forwarned it is going to be a drag to deal with?

Thanks again.

Kevin Loney wrote:

> Can you go up to Oracle8? That would get you up to VARCHAR2(4000) or you
> could use a CLOB datatype to hold up to several Gig per row.
>
> If you have to use 7.3, you'll need to use LONG (which is very limited imo;
> you
> can't insert as select, you can't select across a link, you can't do
> functions
> like LENGTH on them) or you'll need split the column into multiple columns.
> If you split it, you might want to set up a one-to-many relationship
> between
> the main table and a separate table that contains the text values.
> Otherwise,
> your records in your main table would be stored very inefficiently
> (especially
> if you every UPDATE the text values!).
>
> Bottom line: no good solution in Oracle7.
>
> Kevin.
>
> NOTICE TO SPAMMERS: If you send me any unsolicited commercial e-mail
> (including pyramid schemes, chain letters, and MLMs), you hereby grant me
> the right to hunt you down, discover your true identity, and publish your
> personal contact information (including home address and phone number)
> anywhere on the Internet I choose so readers may personally express
> their impressions of your offer directly to you. You hereby agree that in
> doing so, I am providing a service to you, since you desperately crave
> attention. You hereby agree to pay me $10,000 for this service. All
> payments
> should be redirected to a charity of my choice: www.nccf.org. To accept
> these terms, send me a commercial e-mail. You agree to hold me not
> liable for the actions of others. I agree to consider you an idiot.
>
> Paul R. Reed, Jr. <prreed_at_halcyon.com> wrote in article
> <34BB76E0.FABDE5BF_at_halcyon.com>...
> > Hello,
> >
> > What datatype should I use for a text field that needs to be up to 4096
> > in size? I tried long but it is acting like a binary field. Varchar2
> > is too small. I am running Oracle 7.3 on NT.
> >
> > Regards,
> >
> > paul Reed
> > ---------------------------------------------------
> > Jackson-Reed, Inc. Ph 719-598-8615 Fax 719-598-8614
> > "Your Prescription To Client/Server Success"
> > http://www.jacksonreed.com
> >
> >
> >

--
---------------------------------------------------
Jackson-Reed, Inc. Ph 719-598-8615 Fax 719-598-8614
"Your Prescription To Client/Server Success"
http://www.jacksonreed.com