From 5200cd16f5ffc481c76432be1d597f19a3812ec8 Mon Sep 17 00:00:00 2001 From: Lele Gaifax Date: Mon, 12 May 2008 10:09:16 +0000 Subject: [PATCH] Use a BLOB when asked for a [VAR]CHAR without a length under Firebird --- lib/sqlalchemy/databases/firebird.py | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/databases/firebird.py b/lib/sqlalchemy/databases/firebird.py index 098759d183..9f9dcd634f 100644 --- a/lib/sqlalchemy/databases/firebird.py +++ b/lib/sqlalchemy/databases/firebird.py @@ -187,14 +187,20 @@ class FBString(sqltypes.String): """Handle ``VARCHAR(length)`` datatype.""" def get_col_spec(self): - return "VARCHAR(%(length)s)" % {'length' : self.length} + if self.length: + return "VARCHAR(%(length)s)" % {'length' : self.length} + else: + return "BLOB SUB_TYPE 1" class FBChar(sqltypes.CHAR): """Handle ``CHAR(length)`` datatype.""" def get_col_spec(self): - return "CHAR(%(length)s)" % {'length' : self.length} + if length: + return "CHAR(%(length)s)" % {'length' : self.length} + else: + return "BLOB SUB_TYPE 1" class FBBinary(sqltypes.Binary): -- 2.47.3