2007/10/4, Oleg Broytmann <phd@phd.pp.ru>:
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 <davide.alberani@gmail.com>  [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/