According to this MSDN page:
ntext, text, and image data types will be removed in a future version of Microsoft SQL Server.
Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.
How does this affect SQL Server Compact Edition? varbinary(max)
is not currently supported in SQL Server Compact Edition (CE) 4.0.
Going off of what a SQL Server Compact expert said, "Microsoft SQL Server != Microsoft SQL Server Compact".
http://social.msdn.microsoft.com/Forums/en/sqlce/thread/29f05956-cb61-48c4-a6f6-c1e2d9fe5ea5
If that changes, I'm sure MSFT will explain when the older types actually get deprecated.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With