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