| Subject | Re: [firebird-support] Max identifier length? | 
|---|---|
| Author | Martijn Tonies | 
| Post date | 2009-03-18T11:13:13Z | 
Hello Kjell,
It stores names in UNICODE_FSS characterset.
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
            > Is it correct that FB stores identifier names in a system table with a8-bit?
> 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,Yes.
> 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 maxWhat gives you that idea?
> length varies depending on the actual characater content.
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