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.

Reply via email to