NText used for characters in excess of 8000 bytes (=~4000 characters) of unicode content
NText stores upto 1 GB of data (Text stores upto 2 GB of data)
NText cannot be indexed
NText will not employ string functions like Len, Replace
When substr function is used on NText, there is conversion to nvarchar
NVarchar stores upto 4000 characters with unicode support for characters. This is an extra overhead and use this only if it is really needed.
No comments:
Post a Comment