Difference between revisions of "Text field"

From EPrints Documentation
Jump to: navigation, search
(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)