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