Store numeric values in an NVARCHAR column
The database server does not pad a numeric value in an NVARCHAR column with trailing blanks up to the maximum length of the column.
The number of digits in a numeric NVARCHAR value is the number
of characters that you must store that value. For example, the database
server stores a value of
1 in the mytab table
when it executes the following SQL statements:CREATE TABLE mytab (col1 NVARCHAR(10));
INSERT INTO mytab VALUES (1);