Subject Re: [firebird-support] Max identifier length?
Author Martijn Tonies
Hello Kjell,

> Is it correct that FB stores identifier names in a system table with a
> column width of 31 8-byte characters? It seems to me that this is the


It stores names in UNICODE_FSS characterset.

> case, and that it stures identifiers in UTF8 format in this column,
> causing the max identifier length to vary depending on how many
> multi-byte codepoints are used in each name.
> Two questions:
> 1. Any plans to change this so that the identifiers are stored in a
> column with 31 UTF8 characters as max length?
> 2. Any plans to increase the max length in general, regardless of
> encoding?


> Yes, I do have use for longer names, and yes, I do hate that the max
> length varies depending on the actual characater content.

What gives you that idea?

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: