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

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

On Fri, Oct 12, 2007 at 08:02:42AM +0200, Davide Alberani wrote:
> Here we are; Steven Ovits (thanks!) pointed some documentation to me.
> 
> Short version: TEXT and NTEXT are deprecated since SQL Server 2005,
> but they still work today.
> Instead, they suggest to use VARCHAR(MAX) and NVARCHAR(MAX) - yes,
> with this exact syntax; they have a hard cap of 2GB for field.
> Performances are OK.
> 
> I gladly leave to you the decisions about what/how to support. :-)
> 
> Some info:
>   http://msdn2.microsoft.com/en-us/library/ms143729.aspx
>   http://www.teratrax.com/articles/varchar_max.html
> 
> http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1098157,00.html

   Thank you. I will put that "(MAX)" into the code. Also I thing I need to
replace "IMAGE" type for BLOBCol with "VARCHAR(MAX)".

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