Re: 4096 text column?

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
>
>
>
Received on Tue Jan 13 1998 - 00:00:00 CST