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 description and note 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.

Note In the earlier versions of CUBRID 9.0, n represents bite length, not the number of characters.

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).