Text field

From EPrints Documentation
Revision as of 15:52, 10 January 2007 by WikiSysop (talk | contribs)
Jump to: navigation, search

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)