hay77772000 wrote:

> Hi,
>
> We're creating an index on 2 fields as follows:
>
> [java] create table PRINTERGROUP (
> [java] PG_ID numeric(18,0) not null,
> [java] CLASS_DISC varchar(25) not null,
> [java] NAME varchar(172),
> [java] DELETED smallint,
> [java] LASTDISCOVERY timestamp,
> [java] LASTPOLICYAPPLICATION timestamp,
> [java] SSLENABLED smallint,
> [java] primary key (PG_ID),
> [java] unique (CLASS_DISC, NAME)
> [java] )
>
> I know the limit on an index is 252 bytes, so I was expecting to be
> able to make Name a length of 227. However, it will only allow 172
> (index too long error).
>
> Any ideas why?
>
> cheers,
>
> David
>
>

David,

What charset ?

FB 2.0 allows bigger indices.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br