Text field
Description
This is a very simple type of metadata field, which is used as a basis for several others.
It stores a string of text. The maximum possible length of the string is 255 bytes.
Note that 255 bytes does not mean 255 characters! UTF-8 can use 1 to 4 bytes to store a character. ASCII characters (a-z,0-9 etc) only use 1 byte so it will store 255 ASCII characters, but less of latin and much less of chinese.
Properties
| name | default | description |
| sql_index | 0 | as for Metadata but with a different default. |
| text_index | 1 | as for Metadata but with a different default. |
Required Phrases
None
Database
Text fields are stored in the database as
fieldname VARCHAR(255)
