SQL Server - what is the size of nchar(10) and nvarchar(10)

Asked By fatema anwar on 01-Sep-16 01:07 AM
difference between nchar(10) and nvarchaer(10)
Robbe Morris replied to fatema anwar on 01-Sep-16 07:49 AM
char is fixed at 10.  Good if the value will always be the max length.

varchar varies up to 10 (contains extra byte or two to track actual storage)

nchar and nvarchar are the same.  The distinction is that they have storage for various international language characters.