1.

What Is The Differences Between Char And Nchar?

Answer»

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.

Both CHAR and NCHAR are fixed length string data types. But they have the following differences:



Discussion

No Comment Found