Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

NCHAR VARYING(n)

Description

NCHAR VARYING(n) is a variable-length character string type. For details, see descriptions and notes of NCHAR(n). The difference is that the right part (trailing space) of the character string is not filled with whitespace characters, even when the number of strings is smaller than n.

NCHAR VARYING(n), NATIONAL CHAR VARYING(n), and NATIONAL CHARACTER VARYING(n) are used interchangeably.

Example

If you specify '큐브리드' as NCHAR VARYING(5) in the EUC-KR encoding, it is processed normally.

If you specify '큐브리드' as NCHAR VARYING(5) and then use CHAR_LENGTH() function in the EUC-KR encoding, 4 is stored.

If you specify '큐브리드' as HCHAR VARYING(5) in the utf-8 encoding, an error occurs (utf-8 character set is not supported).