Subject Re: [firebird-support] Re: Changing to UNICODE_FSS returns "key size to big on index"
Author Thomas Steinmaurer
> OK, I now understand about the index size limit of 252 bytes
> and that UNICODE_FSS index has a limit of 84 charactes,
> assuming no other columns in the index, such as my BIGINT.
> I've also downloaded "Release Notes 2.0 - Release Candidate 5"
> and I understand that some large portion of this restriction
> is/will be elimiated in v2, although it is not yet precisely
> clear what the actual limitation will be - just that it will
> be "replaced by much-extended limits that depend on page size."

AFAIR it is (page size / 4) - 4

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