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

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

On Thu, Oct 04, 2007 at 12:53:26PM +0200, Davide Alberani wrote:
> I've go a report of a problem with Microsoft SQL Server 9.0: I've a
> SQLObject database structure which uses a number of UnicodeCol
> columns without length limit.
> In other database servers - MySQL, PostgreSQL, ... - these
> columns are correctly mapped to TEXT types, while in SQL Server
> a VARCHAR(4000) is used.

   Does MSSQL Server have an unlimited (or reasonably big) TEXT type? Since
what version? (if I am going to change the type I have at least to document
the lower version of MSSQL that SQLObject requires.)

> 2. any work-around?

   Monkey-patching (if you know what the term means). Or answer my
previous question and wait until a fix appears in a stable release. Or
create tables outside SQLObject.

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