Subject | Indexed column width with FB 2.1 RC1 and "character set utf8 collate unicode"? |
---|---|
Author | jaratulpas |
Post date | 2008-03-06T14:05:14Z |
Hello.
In my Firebird 2.0.3 application, I am creating an index on a varchar
column with "character set utf8 collate unicode".
In Firebird 2.1 RC1 I get following error:
SQL> create database "db.fdb" page_size 8192 default character set ascii;
SQL> create table xx (c varchar(85) character set utf8 collate unicode);
SQL> create index xx_ix on xx(c);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-key size exceeds implementation restriction for index "XX_IX"
Why is the limit on column width just 84 chars in Firebird 2.1 RC1
while it was 339 chars in 2.0.3? (I.e. is it a bug or feature?)
Thanks.
Jara
In my Firebird 2.0.3 application, I am creating an index on a varchar
column with "character set utf8 collate unicode".
In Firebird 2.1 RC1 I get following error:
SQL> create database "db.fdb" page_size 8192 default character set ascii;
SQL> create table xx (c varchar(85) character set utf8 collate unicode);
SQL> create index xx_ix on xx(c);
Statement failed, SQLCODE = -607
unsuccessful metadata update
-key size exceeds implementation restriction for index "XX_IX"
Why is the limit on column width just 84 chars in Firebird 2.1 RC1
while it was 339 chars in 2.0.3? (I.e. is it a bug or feature?)
Thanks.
Jara