TEXT is designed for storing text or strings of characters. SQreamDB blocks non-UTF8 string inputs.
TEXT, specifying a size is optional. If not specified, the text field carries no constraints. To limit the size of the input, use
n is the permitted number of characters.
The following apply to setting the String type length:
If the data exceeds the column length limit on
COPYoperations, SQreamDB will return an error.
When casting or converting, the string has to fit in the target. For example,
'Kiwis are weird birds' :: TEXT(5)will return an error. Use
SUBSTRINGto truncate the length of the string.
String types can be written with standard SQL string literals, which are enclosed with single quotes, such as
'Kiwi bird'. To include a single quote in the string, use double quotations, such as
'Kiwi bird''s wings are tiny'. String literals can also be dollar-quoted with the dollar sign
$, such as
$$Kiwi bird's wings are tiny$$ is the same as
'Kiwi bird''s wings are tiny'.
TEXT(n) can occupy up to 4*n bytes. However, the size of strings is variable and is compressed by SQreamDB.
The following is an example of the String syntax:
CREATE TABLE cool_strings (a TEXT NOT NULL, b TEXT); INSERT INTO cool_strings VALUES ('hello world', 'Hello to kiwi birds specifically'); INSERT INTO cool_strings VALUES ('This is ASCII only', 'But this column can contain 中文文字'); SELECT * FROM cool_strings;
The following is an example of the correct output:
hello world ,Hello to kiwi birds specifically This is ASCII only,But this column can contain 中文文字
Most clients control the display precision of floating point numbers, and values may appear differently in some clients.
String Casts and Conversions
The following table shows the possible String value conversions:
Requires a supported format, such as