This site is scheduled for a small content update on Tuesday, January 22nd, between the hours of 5:00pm and 8:00pm Pacific Time (Jan 23 01:00 – Jan 23 4:00 UTC). Access to this site may be slightly delayed during that time.

Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Database field type

Log in to subscribe to topics and get notified when content changes.

Database field type

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.
Table 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
Image user_image VARCHAR(40)
Due-Date due_date DATETIME