Thank You.
Let me check.
On Wednesday, 14 October 2015 11:11 AM, "'Neil Pickles'
neil.pick...@csy.co.uk [firebird-support]" <firebird-support@yahoogroups.com>
wrote:
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
#yiv2710748107 #yiv2710748107 -- #yiv2710748107ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2710748107
#yiv2710748107ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2710748107
#yiv2710748107ygrp-mkp #yiv2710748107hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2710748107 #yiv2710748107ygrp-mkp #yiv2710748107ads
{margin-bottom:10px;}#yiv2710748107 #yiv2710748107ygrp-mkp .yiv2710748107ad
{padding:0 0;}#yiv2710748107 #yiv2710748107ygrp-mkp .yiv2710748107ad p
{margin:0;}#yiv2710748107 #yiv2710748107ygrp-mkp .yiv2710748107ad a
{color:#0000ff;text-decoration:none;}#yiv2710748107 #yiv2710748107ygrp-sponsor
#yiv2710748107ygrp-lc {font-family:Arial;}#yiv2710748107
#yiv2710748107ygrp-sponsor #yiv2710748107ygrp-lc #yiv2710748107hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2710748107
#yiv2710748107ygrp-sponsor #yiv2710748107ygrp-lc .yiv2710748107ad
{margin-bottom:10px;padding:0 0;}#yiv2710748107 #yiv2710748107actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2710748107
#yiv2710748107activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2710748107
#yiv2710748107activity span {font-weight:700;}#yiv2710748107
#yiv2710748107activity span:first-child
{text-transform:uppercase;}#yiv2710748107 #yiv2710748107activity span a
{color:#5085b6;text-decoration:none;}#yiv2710748107 #yiv2710748107activity span
span {color:#ff7900;}#yiv2710748107 #yiv2710748107activity span
.yiv2710748107underline {text-decoration:underline;}#yiv2710748107
.yiv2710748107attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2710748107 .yiv2710748107attach div a
{text-decoration:none;}#yiv2710748107 .yiv2710748107attach img
{border:none;padding-right:5px;}#yiv2710748107 .yiv2710748107attach label
{display:block;margin-bottom:5px;}#yiv2710748107 .yiv2710748107attach label a
{text-decoration:none;}#yiv2710748107 blockquote {margin:0 0 0
4px;}#yiv2710748107 .yiv2710748107bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2710748107
.yiv2710748107bold a {text-decoration:none;}#yiv2710748107 dd.yiv2710748107last
p a {font-family:Verdana;font-weight:700;}#yiv2710748107 dd.yiv2710748107last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2710748107
dd.yiv2710748107last p span.yiv2710748107yshortcuts
{margin-right:0;}#yiv2710748107 div.yiv2710748107attach-table div div a
{text-decoration:none;}#yiv2710748107 div.yiv2710748107attach-table
{width:400px;}#yiv2710748107 div.yiv2710748107file-title a, #yiv2710748107
div.yiv2710748107file-title a:active, #yiv2710748107
div.yiv2710748107file-title a:hover, #yiv2710748107 div.yiv2710748107file-title
a:visited {text-decoration:none;}#yiv2710748107 div.yiv2710748107photo-title a,
#yiv2710748107 div.yiv2710748107photo-title a:active, #yiv2710748107
div.yiv2710748107photo-title a:hover, #yiv2710748107
div.yiv2710748107photo-title a:visited {text-decoration:none;}#yiv2710748107
div#yiv2710748107ygrp-mlmsg #yiv2710748107ygrp-msg p a
span.yiv2710748107yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2710748107
.yiv2710748107green {color:#628c2a;}#yiv2710748107 .yiv2710748107MsoNormal
{margin:0 0 0 0;}#yiv2710748107 o {font-size:0;}#yiv2710748107
#yiv2710748107photos div {float:left;width:72px;}#yiv2710748107
#yiv2710748107photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2710748107
#yiv2710748107photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2710748107
#yiv2710748107reco-category {font-size:77%;}#yiv2710748107
#yiv2710748107reco-desc {font-size:77%;}#yiv2710748107 .yiv2710748107replbq
{margin:4px;}#yiv2710748107 #yiv2710748107ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2710748107 #yiv2710748107ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2710748107
#yiv2710748107ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2710748107
#yiv2710748107ygrp-mlmsg select, #yiv2710748107 input, #yiv2710748107 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2710748107
#yiv2710748107ygrp-mlmsg pre, #yiv2710748107 code {font:115%
monospace;}#yiv2710748107 #yiv2710748107ygrp-mlmsg *
{line-height:1.22em;}#yiv2710748107 #yiv2710748107ygrp-mlmsg #yiv2710748107logo
{padding-bottom:10px;}#yiv2710748107 #yiv2710748107ygrp-msg p a
{font-family:Verdana;}#yiv2710748107 #yiv2710748107ygrp-msg
p#yiv2710748107attach-count span {color:#1E66AE;font-weight:700;}#yiv2710748107
#yiv2710748107ygrp-reco #yiv2710748107reco-head
{color:#ff7900;font-weight:700;}#yiv2710748107 #yiv2710748107ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2710748107 #yiv2710748107ygrp-sponsor
#yiv2710748107ov li a {font-size:130%;text-decoration:none;}#yiv2710748107
#yiv2710748107ygrp-sponsor #yiv2710748107ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2710748107
#yiv2710748107ygrp-sponsor #yiv2710748107ov ul {margin:0;padding:0 0 0
8px;}#yiv2710748107 #yiv2710748107ygrp-text
{font-family:Georgia;}#yiv2710748107 #yiv2710748107ygrp-text p {margin:0 0 1em
0;}#yiv2710748107 #yiv2710748107ygrp-text tt {font-size:120%;}#yiv2710748107
#yiv2710748107ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2710748107
