Range of Type
This type of field can effectively store string values of variable size practically without any limit (it is 2Gb actually).
This field uses a logical file of segmented structure to be able effectively store strings of variable length from very small to very big. Read more...
This field can be declared as Nullable. In this case a special bitmap is associated with this field.
This field can have flag fIndexed.
This field can have flag fUnique.
This field can have fIndexByWords flag.
This field type is represented at the API level by VText Class.
At SQL Level you can create such field using
CREATE TABLE T1( fldText TEXT(256) INDEX BY WORDS );
You can use this field in any predicate expression, e.g.
SELECT * FROM T1 WHERE fldText = 'Peter';