Subject Re: [firebird-support] Cannot Create Index
Author Vishal Tiwari
Post date 2015-10-14T05:18:33Z
How to increase the database page size 16kb ?



On Tuesday, 13 October 2015 9:00 PM, "Fabiano Kureck fabiano@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:


 
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