Subject | Re: [firebird-support] Re: Changing to UNICODE_FSS returns "key size to big on index" |
---|---|
Author | Thomas Steinmaurer |
Post date | 2006-10-13T20:23:08Z |
> OK, I now understand about the index size limit of 252 bytesAFAIR it is (page size / 4) - 4
> 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."
--
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