Issue Details (XML | Word | Printable)

Key: CORE-749
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Pavel Cisar
Votes: 49
Watchers: 25

If you were logged in you would be able to see more operations.
Firebird Core

Increase maximum length of object names to 63 characters

Created: 17/Sep/03 12:00 AM   Updated: 30/Oct/19 03:02 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 4.0 Alpha 1

Issue Links:

SF_ID: 807895
QA Status: Covered by another test(s)
Test Details: See test core_2350.fbt (no more troubles with this ticket issue, so it can be closed).

 Description  « Hide
SFID: 807895#
Submitted By: pcisar

Like other RDBMS's we should be supporting longer
object names.
User: nobody
Logged In: NO

Longer identifiers are useful, but remember that Oracle
supports 30 character identifiers, so this would impact DB
portability. A switch would be nice.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Fidel Viegas added a comment - 03/Jul/11 06:33 PM
This would be a really nice feature, as it sometimes complicates when we try to make an application compatible with various RDBMS. This is the only restriction I find when I try to port applications from other RDBMS. It forces one to rename object names to adjust to this limitation, and this sometimes breaks code that was already working. Specially when you are dealing with frameworks like Ruby on Rails.

I do understand that if it wasn't yet implemented is because somehow it is a difficult task, but the truth is that it sometimes forces us to do extra work when porting from other RDMBS.



Tim Kelly added a comment - 20/May/12 09:09 PM
Any chance of this making it into version 3. It's such as frustrating limitation.



Valdir Marcos added a comment - 24/Dec/12 05:18 PM
I could not find this request neither on Release Notes - Firebird Core - Version 3.0 Alpha 1 - HTML format ( nor on Roadmap last updated in November 2012 (

It is really useful on object-oriented programming (OOP) and on porting from other RDMBS to Firebird.

Can we hope this improvement to be scheduled for Firebird 3?

Dmitry Yemanov added a comment - 24/Dec/12 05:34 PM
No, it's not planned for v3.0.

Sean Palmer added a comment - 04/Dec/14 12:07 PM
Any progress on this please?
It is extremely frustrating that this limitation still exists in Firebird and is severely restricting the use of Firebird for my projects where long identifiers are required and for porting from other DBMS such as MSSQL or MS Access!

Todd Manchester added a comment - 06/Apr/16 08:35 PM
I appreciate all that you do! I too was hoping this would make it into v3.0. But understand there needs to be limits. Just my 2 cents.

Karol Bieniaszewski added a comment - 29/Apr/16 09:26 AM
If we are talking about compatibility
then object names should be not 64 but 128 chars like in MSSQL