T-SQL Tutorial

Nchar - TSQL Tutorial


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