Re: Oracle 7: Longer fields?

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.)