Thread: NCHAR datatype

What is the use of NCHAR datatype? In applications where can we use NCHAR datatype?

Fixed length national character set data of length size bytes. This should be used for fixed length data. Such as codes A100, B102

The NCHAR data type stores fixed-length character data. The data can be a string of single-byte or multibyte letters, digits, and other symbols that are supported by the code set of the database locale. The main difference between CHAR and NCHAR data types is the collating order.

The collation order of the CHAR data type follows the code-set order, but the collating order of the NCHAR data type can be a localized order, if DB_LOCALE (or SET COLLATION) specifies a localized collation. For more information about NCHAR