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, see the description of DBNLS (IDS).
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]