NCHAR(n)

Description

NCHAR(n) is used to store non-English character strings. It can be used only for character sets supported by CUBRID described above. n is the number of characters. If n is omitted, the length is specified as the default value 1. When the length of a character string exceeds n, they are truncated. When character string which is shorter than n is stored, whitespace characters are used to fill up the  space.

To store a Korean character string as a national character string type, you must set the locale of the operating system to Korean, or set the value of the CUBRID_LANG environment variable to ko_KR.euckr before creating the table.

Remark
Example

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

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

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