By 26/03/2016 1 Comments

SQL Server ntext vs nvarchar(MAX) Datatypes

  • SQL Server offers ntext and nvarchar(MAX) datatypes for storing multi lingual string based information/values.
  • There are some difference between ntext and nvarchar(MAX) datatypes:
  • The ntext datatype stores unicode string with maximum 2GB of data.
  • The nvarchar(MAX) datatype stores unicode string with maximum 536,870,912 characters.
  • The ntext datatype has many disadvantages such as it does not support string built-in functions, create complexity, hard to handle etc.
  • The nvarchar(MAX) datatype has many advantages along with good performance such as it supports many built-in functions, easy to use, flexible, fast etc and it is also recommended by Microsoft.
  • The ntext and text datatypes haveĀ also been deprecated by Microsoft in the future release of SQL Server.

Posted in: ASP.NET, Solutions, Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .