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

MySQL silently truncates text fields to 64kb

XMLWordPrintable

      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.

            [CRUC-1824] MySQL silently truncates text fields to 64kb

            Marek Parfianowicz made changes -
            Component/s New: Server administration [ 50891 ]
            Component/s Original: Database [ 12766 ]
            Owen made changes -
            Workflow Original: FE-CRUC Bug Workflow [ 2941693 ] New: JAC Bug Workflow v3 [ 2954051 ]
            Owen made changes -
            Workflow Original: FECRU Development Workflow - Triage - Restricted [ 1514770 ] New: FE-CRUC Bug Workflow [ 2941693 ]
            Owen made changes -
            Workflow Original: FECRU Development Workflow - Triage [ 938860 ] New: FECRU Development Workflow - Triage - Restricted [ 1514770 ]
            Piotr Swiecicki made changes -
            Workflow Original: FECRU Development Workflow (Triage) [ 315393 ] New: FECRU Development Workflow - Triage [ 938860 ]
            Seb Ruiz (Inactive) made changes -
            Workflow Original: Simple review flow with triage [ 178520 ] New: FECRU Development Workflow (Triage) [ 315393 ]
            sladey made changes -
            Fix Version/s New: 2.1 [ 14693 ]
            sladey made changes -
            Labels New: fecru_21_m1
            Erik van Zijst (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: To be reviewed [ 10026 ] New: Closed [ 6 ]
            Erik van Zijst (Inactive) made changes -
            Status Original: In Progress [ 3 ] New: To be reviewed [ 10026 ]

              evzijst Erik van Zijst (Inactive)
              evzijst Erik van Zijst (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved:

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