2007/10/10, Oleg Broytmann <[EMAIL PROTECTED]>:
>
> 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 <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47]
http://erlug.linux.it/~da/
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
