Skip to main content

STRING

STRING​

Description​

A variable length string. Default support is 1048576 bytes (1M), adjustable up to 2147483643 bytes (2G),and the length of the String type is also limited by the configuration string_type_length_soft_limit_bytes(a soft limit of string type length) of be. the String type can only be used in the value column, not in the key column and the partition and bucket columns

Note: Variable length strings are stored in UTF-8 encoding, so usually English characters occupies 1 byte, and Chinese characters occupies 3 bytes.

keywords​

STRING

Type aliases and metadata display​

STRING and TEXT define the same Doris type. Different interfaces display that type differently:

InterfaceDisplay for a STRING column
SHOW CREATE TABLE and DESCtext
information_schema.columns.DATA_TYPEvarchar, for MySQL compatibility
information_schema.columns.COLUMN_TYPEstring

These names do not change the stored type or its length limit. To distinguish a Doris STRING column from a length-limited VARCHAR column in metadata, check COLUMN_TYPE.