Hi, What is the difference between these two data types in SSCE 4.0:
nchar(n) and nvarchar(n)
here states for nchar(n):
Fixed-length Unicode data with a maximum length of 4000 characters. Default length = 1. Storage size, in bytes, is two times
the number of characters entered.
and for nvarchar(n):
Variable-length Unicode data with a length of 1 to 4000 characters. Default length = 1. Storage size, in bytes, is two times the number of characters entered.
I presume by "number of characters entered" it is meant "number of characters stored for the column value in the table row".
But if that is true, it is not clear to me how nchar is "fixed-length", nor how it is different to
Any help with this would be much appreciated.
View Complete Post