Skip to main content

String

String Data Types

In Databend, strings can be stored in the VARCHAR field, the storage size is variable.

NameAliasesStorage Size
VARCHARSTRINGvariable

Functions

See String Functions.

Example

CREATE TABLE string_table(text VARCHAR);

DESC string_table;
+-------+---------+------+---------+
| Field | Type | Null | Default |
+-------+---------+------+---------+
| text | VARCHAR | NO | |
+-------+---------+------+---------+

INSERT INTO string_table VALUES('databend');

SELECT * FROM string_table;
+----------+
| text |
+----------+
| databend |
+----------+