Switch to: V9V8V7V6V5

String Field

Range of Type

This type of field can store string values with the length up to 65,536 characters.

Storage

This field uses FIXED size for storage of all records. For example, String(20) field, with the UTF-16 storage encoding, will use 40 bytes on disk. If the string value is shorter than 20, then the remaining characters are filled by zeros.

Flags

  • fNullable

This field can be declared as Nullable. In this case a special bitmap is associated with this field.

  • fIndexed

This field can have flag fIndexed.

  • fUnique

This field can have flag fUnique.

* fIndexByWords

This field can have fIndexByWords flag.

Read Mode About Field Flags

API

This field type is represented at the API level by VString Class.

SQL

At SQL Level you can create such field using

CREATE TABLE T1( fldString STRING(20) );

You can use this field in any predicate expression, e.g.

SELECT * FROM T1 WHERE fldString = 54;