Skip to main content Link Menu Expand (external link) Document Search Copy Copied

STRING data type

Syntax

STRING

Arguments

Argument Description
STRING Used for STRING, CHAR and VARCHAR data.

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:

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%';