Why IB field name cannot be determind unambiguously?

Well, I have a field FIELD_NAME defined over domain DOMAIN_NAME (as varchar), and filed length is different in different places of IBConsole:

in tabSheet "Properties" (for table containing FIELD_NAME):
FIELD_NAME (DOMAIN_NAME) VARCHAR(30)

in tabSheet "Properties" (for domain DOMAIN_NAME)
VARCHAR(80)

"select * from rdb$fields where rdb$field_name='DOMAIN_NAME'"
gives
RDB$FIELD_LENGTH=80,

and also Delphi TQuery gives length (size) 80 in case of "Add fields". (Very rarely it can lead to error messages '.. expecting 80 actual: 30')

However - IBExpert in all cases gives 30 as domain and field length.

OK, sometimes after 'alter domain DOMAIN_NAME type VARCHAR(80)' the pair of strange numbers appears to be different: (80, 82) instead if (30, 80).

Where the error can be?

Thanks for any suggestions in advance!

Two things:

1) you're posting in a Firebird group. IB has a bug in v6 that when increasing size, it adds 2.

2) have a look at RDB$CHARACTER_LENGTH, not just field_length.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com