Both CHAR and NCHAR are fixed length string data types. But they have the following differences:
=>CHARs full name is CHARACTER.
=>NCHARs full name is NATIONAL CHARACTER.
=>By default, CHAR uses ASCII character set. So 1 character is always stored as 1 byte.
=>By default, NCHAR uses Unicode character set. NCHAR data are stored in UTF8 format. So 1 character could be stored as 1 byte or upto 4 bytes.
=>Both CHAR and NCHAR columns are defined with fixed lengths in units of characters.
=>CHARs full name is CHARACTER.
=>NCHARs full name is NATIONAL CHARACTER.
=>By default, CHAR uses ASCII character set. So 1 character is always stored as 1 byte.
=>By default, NCHAR uses Unicode character set. NCHAR data are stored in UTF8 format. So 1 character could be stored as 1 byte or upto 4 bytes.
=>Both CHAR and NCHAR columns are defined with fixed lengths in units of characters.
No comments:
Post a Comment