Difference between revisions of "Text field"
(→Required Phrases) |
|||
| Line 23: | Line 23: | ||
None | None | ||
| + | |||
| + | == Database == | ||
| + | |||
| + | Text fields are stored in the database as | ||
| + | |||
| + | fieldname VARCHAR(255) | ||
Revision as of 15:52, 10 January 2007
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)
