Re: [SQLObject] SQL Server varchar(4000) instead of TEXT

[Davide A. <dav...@gm...>]

2007/10/4, Oleg Broytmann <ph...@ph...>:
>
> On Thu, Oct 04, 2007 at 12:53:26PM +0200, Davide Alberani wrote:
> Does MSSQL Server have an unlimited (or reasonably big) TEXT type?


I've never used it directly, I'll have to ask for the details: my contact
tried to
change 'VARCHAR(4000)' to 'TEXT', in col.py, and it worked (slow as hell,
but that's
probably a SQLServer issue).

Since what version?


I can find documentation (in Italian), citing TEXT (up to 2147483647 chars)
and NTEXT for
unicode (up to 1073741823 chars).  It refers to SQL Server 7.0.


> > 2. any work-around?
>
>    Monkey-patching (if you know what the term means).


Yup - that's always an option, but I prefer to consider it a last resort.


Thank you!
-- 
Davide Alberani <dav...@gm...>  [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/