how can a field of type text be defined? shorttext text(512), shorttext text, both don't work? CREATE TABLE tb_test ( id INTEGER NOT NULL, shorttext text(512), longtext text ); Heinrich