String Data Types
In Databend, strings can be stored in the VARCHAR field, the storage size is variable.
| Name | Aliases | Storage Size |
|---|---|---|
| VARCHAR | STRING | variable |
Functions
See String Functions.
Example
CREATE TABLE string_table(text VARCHAR);
DESC string_table;
Result:
┌──────────────────────────────────────────────┐
│ Field │ Type │ Null │ Default │ Extra │
├────────┼─────────┼────────┼─────────┼────────┤
│ text │ VARCHAR │ YES │ NULL │ │
└──────────────────────────────────────────────┘
INSERT INTO string_table VALUES('databend');
SELECT * FROM string_table;
Result:
┌──────────────────┐
│ text │
├──────────────────┤
│ databend │
└──────────────────┘