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


8-bit?

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.

> 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
http://www.upscene.com

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

Database questions? Check the forum:
http://www.databasedevelopmentforum.com