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.
|sql_index||0||as for Metadata but with a different default.|
|text_index||1||as for Metadata but with a different default.|
Text fields are stored in the database as