Re: Maximum Key Lengths for Windows?

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/10/14
Message-ID: <61vmh4$8qg$1@news02.btx.dtag.de>#1/1

Jonathan Calvert wrote:
>
> I am getting a ORA-01450 error message when creating
> an index on a varchar2(1000) field.
>
> The error says that "the maximum index length varies
> by operating system".
>
> Does anyone know what this length is for Windows 3.x?
>
> I am using Oracle 7 Workgroup Server Version 7.1.4.3.4
> for NetWare.
>
> Thanks.
>
> -Jonathan

Hi,

windows can only handle VARCHAR2(255) as string 'cause Access strings are limited by 255. VARCHAR2(1000) will be handled as memo-field which can't be indexed.

But I think you've to care about the maximum index length for Netware.

-- 
Regards

M.Gresz    :-)

Received on Tue Oct 14 1997 - 00:00:00 CDT