Data types for MB fields

Purdue Alumni Association
Home / MB Custom Table / Data types for MB fields

Custom Fields
Re-Envisioned › Support › MB Custom Table › Data types for MB fields

  • Creator
    Topic
  • October 19, 2018 at 2:27 AM #11668
    Resolved Purdue Alumni Association
    Participant

    Is there a reference list of what data types should/can be used for each column in a custom table?

    The code examples only map what I assume are text fields (address, phone, and email) to TEXT NOT NULL and VARCHAR(20) NOT NULL

    I am most interested in what data type to use for radio button groups, checkbox lists, image advanced, wysiwyg, and post.

  • Creator
    Topic
Viewing 1 replies (of 1 total)
  • Author
    Replies
  • October 20, 2018 at 8:14 AM #11682
    Anh Tran
    Keymaster

    Hi Purdue,

    All types should use text or equivalent type for storing the data. So TEXT NOT NULL is the general type.

    But if your data is short, or you want to tell MySQL to index the field (e.g., making the field a key), then you should use VARCHAR(length) NOT NULL. MySQL can’t index a text field without knowing its max length.

  • Author
    Replies
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.