Just back it up and restore it using gbak and use the - P 16384 parameter to change the page size when restoring it.
Regards, Neil Pickles – n...@csy.co.uk ----- Reply message ----- From: "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" <firebird-support@yahoogroups.com> To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com> Subject: [firebird-support] Cannot Create Index Date: Wed, Oct 14, 2015 06:18 How to increase the database page size 16kb ? On Tuesday, 13 October 2015 9:00 PM, "Fabiano Kureck fabi...@sci10.com.br [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 vishuals...@yahoo.co.in [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
