sqlobject-discuss

[SQLObject] Changing 'TEXT' to 'LONGTEXT'

[Markus G. <m.g...@gm...>]

Hi,

how about changing 'TEXT' to 'LONGTEXT' for SOStringLikeCol?  'TEXT'
is to short in some cases.

--- sqlobject_orig/col.py       2007-04-10 17:58:32.000000000 +0200
+++ sqlobject/col.py    2007-04-12 22:54:12.105342400 +0200
@@ -455,7 +455,7 @@
         if self.customSQLType is not None:
             return self.customSQLType
         if not self.length:
-            return 'TEXT'
+            return 'LONGTEXT'
         elif self.varchar:
             return 'VARCHAR(%i)' % self.length
         else:

Kind regards,
Markus

Re: [SQLObject] Changing 'TEXT' to 'LONGTEXT'

[Oleg B. <ph...@ph...>]

On Fri, Apr 13, 2007 at 11:05:54PM +0200, Markus Gritsch wrote:
> how about changing 'TEXT' to 'LONGTEXT' for SOStringLikeCol?  'TEXT'
> is to short in some cases.

   -1. TEXT, CHAR and VARCHAR are standard SQL types, universally
recognized by all backends. LONGTEXT is MySQL'ish extension.
   You can use customSQLType or BLOBCol. See col.py.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Changing 'TEXT' to 'LONGTEXT'

[Markus G. <m.g...@gm...>]

On 4/14/07, Oleg Broytmann <ph...@ph...> wrote:
> On Fri, Apr 13, 2007 at 11:05:54PM +0200, Markus Gritsch wrote:
> > how about changing 'TEXT' to 'LONGTEXT' for SOStringLikeCol?  'TEXT'
> > is to short in some cases.
>
>    -1. TEXT, CHAR and VARCHAR are standard SQL types, universally
> recognized by all backends. LONGTEXT is MySQL'ish extension.
>    You can use customSQLType or BLOBCol. See col.py.

Ah, thanks.  I use sqlType='LONGTEXT' as keyword-argument now.

Kind regards,
Markus