November 24th, 2003, 07:20 AM
Primary columns length combinely should be less than or equal to 250 bytest in FireBird.
Due to this the size of the column should be minimal. Can anybody know, this issue has got fixed in FireBird.
November 24th, 2003, 10:07 PM
At the Firebird website, they list all the changes they make for each version. I could not find where this limitation has been changed:
Fortunately this is an item that you can test yourself by creating a long primary key and seeing if it works with the version you're using. If it fails, you know the limitation still exists in your version.
November 24th, 2003, 11:05 PM
Primary key length
Actually I am using 1.0.3 Release version of FireBird. In this restriction for primary key column length is there. so i want to know whether the same is fixed in any later versions.
November 24th, 2003, 11:17 PM
I could not find mention of this fix in Version 1.5 RC7.
Version 184.108.40.20673 on my laptop would not let me create a 300 byte index.
November 24th, 2003, 11:51 PM
Do u know any workaround for this
November 25th, 2003, 12:11 AM
Use a surrogate key (a sequence number) instead of a natural key (a long multi-field key). This will allow you to relate one table to another. You still might have a problem if in order to maintain the integrity of your data you need to create a unique index on the natural key. You'll still run into that 250 byte limit.