Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-1824

MySQL silently truncates text fields to 64kb

    XMLWordPrintable

    Details

      Description

      We use the TEXT datatype for large character fields, but this only holds a maximum of 64kb of data, or 65535 non-multibyte characters (when multibyte characters are used, this could be as little as 21845 characters).

      MySQL accepts any string and silently truncates it when storing.

      Solution is to move to larger datatypes such as MEDIUMTEXT (holds max 2^24 = 16,777,215 bytes) or LONGTEXT (2^32 = 4,294,967,295 or 4GB).

      It's important to investigate the effects this may have on our full text comment search.

        Attachments

          Activity

            People

            Assignee:
            evzijst Erik van Zijst
            Reporter:
            evzijst Erik van Zijst
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 8h 10m
                8h 10m