Database field type

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：2分

    • Several field types are available in the system.

    This table shows field types and corresponding MySQL database types. Typically, it isn't necessary to perform any actions at the database level. To learn about changing a field type, see System dictionary.
    表 : 1. Database field types
    Field types Options Dictionary XML type MySQL DB type
    String small string VARCHAR(40)
    String medium string VARCHAR(100)
    String large string MEDIUMTEXT
    String extralarge string MEDIUMTEXT
    Decimal decimal Decimal (15,2) older instances may have (12,2)
    Integer integer Integer
    True-False boolean TINYINT(1)
    Date glide_date DATE
    Date-Time glide_date_time DATETIME
    Time glide_time DATETIME
    Duration glide_duration DATETIME
    Choice string VARCHAR(40)
    Suggestion string VARCHAR(40)
    Journal journal MEDIUMTEXT
    Reference <reference table> reference VARCHAR(32)
    List glide_list MEDIUMTEXT
    Url url MEDIUMTEXT
    Image user_image VARCHAR(40)
    Due-Date due_date DATETIME
    注:
    An example of option types is as follows:
    • A string field defined in the platform with a max length of 40 characters → VARCHAR(40).
    • A string field defined in the platform with a max length of x, where x = 41-255 characters, inclusive → VARCHAR(x) [examples: String 42 is VARCHAR(42) and String 211 is VARCHAR(211)].
    • A string field defined in the platform with a max length of 256 and upwards → MEDIUMTEXT.