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:
| Interface | Display for a STRING column |
|---|---|
SHOW CREATE TABLE and DESC | text |
information_schema.columns.DATA_TYPE | varchar, for MySQL compatibility |
information_schema.columns.COLUMN_TYPE | string |
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.