The field is TEXT: sqlite> .schema operators CREATE TABLE operators ( uid INTEGER PRIMARY KEY, id TEXT UNIQUE NOT NULL CHECK(length(id) BETWEEN 1 AND 20), name TEXT CHECK(length(trim(name)) > 0) );
Glyn.
The field is TEXT: sqlite> .schema operators CREATE TABLE operators ( uid INTEGER PRIMARY KEY, id TEXT UNIQUE NOT NULL CHECK(length(id) BETWEEN 1 AND 20), name TEXT CHECK(length(trim(name)) > 0) );
Glyn.