CODEWITHSUNDEEP
firebirdfirebird-embedded
wwahammy
wwahammy

Reputation: 465

Is it possible to extend Firebird table name length?

I'm a Firebird newbie here. I'm trying to use Firebird Embedded from an ASP.Net application. Everything connects fine but I'm running into problems with the length of column names. I'm trying to create a table named "Orchard_Framework_DataMigrationRecord." I keep getting an exception which says "Name longer than database column size." After some investigation, I've seen that a number of people have mentioned that Firebird has a column name length limit of 20 characters.

Is that correct and if so is there any way to change it? In my case, I can't change the name of the table; it really has to be that long.

Upvotes: 9

Views: 10072

Answers (2)

Miguel Angel Suarez Rodriguez
Miguel Angel Suarez Rodriguez

Reputation: 61

This appears to be fixed as of Firebird version 4.0 Alpha 1: Increase maximum length of object names to 63 characters

Upvotes: 4

ain
ain

Reputation: 22749

Unfortunately there is no way to change the maximum identifier length, it's an implementation limit. There is a plan to remove this limitation but in current version (2.5) the max identifier length is 31 characters.

Upvotes: 12

Related Questions