Subject Re: [firebird-support] Cannot Create Index
Author Neil Pickles
Post date 2015-10-14T05:41:07Z
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 – neil@...

----- Reply message -----
From: "Vishal Tiwari vishualsoft@... [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 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