Re: Oracle 7: Longer fields?
Date: 12 Jan 1994 21:17:31 GMT
Message-ID: <2h1pdb$999_at_terminator.rs.itd.umich.edu>
In article <2h1hd5$r3v_at_linus.mitre.org>, Marc Cannava <mnc_at_mitre.org> wrote:
>Does Oracle V7 allow multiple fields in a table to be longer than 255
>characters? That's one of the major limitations we're finding in
>designing a database under V6. We need to have multiple fields that
>contain free-form text which could be on the order of 20-30K. I know
>that Oracle V6 only allows ONE field per table to be declared LONG,
>and that doesn't help.
As I understand it you can have as many fields in V7 that are either varchar2 (up to 2k characters) or raw (up to 2k of binary data) as other limits (total row size, etc) will permit. You are still limited to one LONG or LONG RAW data type per table, but these can now contain up to 2gigabytes. I met my first customer today who was unhappy with the 2G limit. <sigh>
Note: Oracle7 the Complete Reference by George Koch lists the raw data type as limited to 240 bytes, but I believe this is incorrect.
-- ________________________________________ Jack F. Love | Opinions expressed are mine alone. | (Unless you happen to agree.)Received on Wed Jan 12 1994 - 22:17:31 CET