Subject Re: [firebird-support] Cannot Create Index
Author Fabiano Kureck
Post date 2015-10-13T15:30:42Z
Maximum key size is one quarter of page size. What is your database page size? What is the collation of that field?
Try increase database page size to 16Kb

Em 13/10/2015 12:20, Vishal Tiwari vishualsoft@... [firebird-support] escreveu:
 
Hi All,

I am trying to create index on a field which is of data type Varchar(255) using FlameRobin, while committing I get below error message:

key size exceeds implementation restriction for index "IDX_<INDEXNAME>"


How do I create an index on a field which is of data type Varchar(255) ?

Thanks In Advance.

With Best Regards.

Vishal