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

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

2007/10/10, Oleg Broytmann <ph...@ph...>:

>
>    Ok, waiting...
>

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


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