Saturday, June 29, 2013

nvarchar(n) and nvarchar(max) different datatypes?


In a nutshell, it appears that you cannot use a NVARCHAR(MAX) in an index using SQL Server 2012 SP1



An add on on this, the same behaviour on SQL server 2008 R2. You cannot create an index on an NVARCHAR(MAX). BOL should be more clear about this.


Again, not that I would index an NVARCHAR(MAX)




Kind regards M


No comments:

Post a Comment