Subject Re: [firebird-support] Re: Firebird 2.5 maximum length for each type of identifier
Author Helen Borrie
>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


>or if the DB default charset or something else determines this. Anyone know?

The DB default charset doesn't influence the charset of identifiers.