On Transact SQL language the nchar is part of unicode character strings data types and have fixed length. The string length must be a value from 1 through 4,000.
Nchar syntax:
nchar [ ( n ) ]
Nchar example:
USE model;
GO
CREATE TABLE myNcharTable ( a nchar(20) );
GO
INSERT INTO myNcharTable VALUES ('This is an example');
GO
SELECT a FROM myNcharTable;
GO
Results |
---|
This is an example |