From 34a35b10525e5124756d06552a14a5f61807b5cb Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Tue, 8 May 2007 17:55:41 +0000
Subject: [PATCH] - set max identifier length to 31

---
 CHANGES                              | 2 ++
 lib/sqlalchemy/databases/firebird.py | 3 +++
 2 files changed, 5 insertions(+)

diff --git a/CHANGES b/CHANGES
index 193025ab29..1c13273d9d 100644
--- a/CHANGES
+++ b/CHANGES
@@ -16,6 +16,8 @@
 - mysql
     - support for column-level CHARACTER SET and COLLATE declarations,
       as well as ASCII, UNICODE, NATIONAL and BINARY shorthand.
+- firebird
+    - set max identifier length to 31
 -extensions
     - new association proxy implementation, implementing complete
       proxies to list, dict and set-based relation collections
diff --git a/lib/sqlalchemy/databases/firebird.py b/lib/sqlalchemy/databases/firebird.py
index d05b406507..0f55c856c1 100644
--- a/lib/sqlalchemy/databases/firebird.py
+++ b/lib/sqlalchemy/databases/firebird.py
@@ -154,6 +154,9 @@ class FBDialect(ansisql.ANSIDialect):
     def preparer(self):
         return FBIdentifierPreparer(self)
 
+    def max_identifier_length(self):
+        return 31
+
     def has_table(self, connection, table_name, schema=None):
         tblqry = """
         SELECT count(*)
-- 
2.47.2