DO NOT USE NTEXT
Friday, February 8th, 2008Today I learned something new. Not new to the world, but just new to me:
DO NOT USE NTEXT !
I don’t know why it is still possible to create ntext attributes in MS CRM 4.0, but I learned that in the real SQL world they are no longer used. Ok, you may still want to use it for field with more than 4000 characters, but in most crm systems this is not advisable.
Quote:
“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. For more information, see Using Large-Value Data Types.”
Source: MSDN SQL Server Developer Center
