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 |
For more information, see Oracle to SQL Server Migration.