Subject Re: [firebird-support] Indexed column width with FB 2.1 RC1 and "character set utf8 collate unicode"?
Author Thomas Steinmaurer
> 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?)

This has been fixed for 2.1 RC2.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com