STRING data type

Syntax

STRING

Arguments

Additional information

The STRING data type has a keyed mutex internal data type and recommended for queries:

• on discrete values,
• with group by where cardinality is low

High cardinality data will:

• decrease performance
• increase storage overheads

Constraining string values

Single quotation marks are used for string values in the following statements:

• INSERT/REPLACE
• SELECT

Examples

create table products
  (_id id, item string, price decimal(2) stock int);
create table services
  (_id id, servicelist string, price decimal(2));

SELECT FROM string column

SELECT * FROM products WHERE item LIKE '%pen%';