CHAR Data type - Oracle to SQL Server Migration

Oracle and SQL Server provide the CHAR(n) data type to store fixed-length character data right-padded with blanks to the specified n length:

Oracle		SQL Server
CHAR		CHAR
CHAR(n)		CHAR(n)
CHAR(n CHAR)	Size in characters
CHAR(n BYTE)	Size in bytes
1 <= n <= 2000, default is 1		1 <= n <= 8000, default is 1
Size n in characters or bytes, but the storage limit is 2000 bytes		Size n in bytes
Default length semantics is defined by NLS_LENGTH_SEMANTICS parameter
Trailing spaces are retained on read		Trailing spaces are retained on read

Synonyms:

Oracle		SQL Server
CHARACTER		CHARACTER