Does anyone know why are they are still restricted to only 31 characters? Why can't they be increased to 64 characters?

This is a major headache especially when porting databases from other databases e.g.. MS SQL

Sean.

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
>
> >tomkrej skriver:
> >> Hi, all max.lengths for firebird are 31 characters.
>
> At 09:56 PM 12/11/2010, Kjell Rilbe wrote:
>
> >If I'm not mistaken, they are max 32 *byte*.
>
> You are mistaken, unfortunately. 31 *characters* is correct. Furthermore, I believe it was demonstrated at some point that the identifiers of triggers (and possibly also stored procedures) will overflow if defined as 28 characters or more.
>
> >If you use UTF-8 and some
> >chars are multi-byte, the max number of characters goes down in
> >proportion to the number of extra bytes used by multi-byte chars.
>
> Identifiers (including user names) are stored in UNICODE_FSS, three bytes per character, no variability.
>
> >Not sure if identifiers are always stored in UTF-8
>
> Never.
>
> >or if the DB default charset or something else determines this. Anyone know?
>
> The DB default charset doesn't influence the charset of identifiers.
>
> ./heLen
>