Nitin Jain Nitin Jain - 6 months ago 48
SQL Question

1265 data truncated for column at row 1 after few values

hello i am trying to add data to mysql column but after some data has been input it throws subject mentioned error

The structure is
enter image description here

the column data format is
enter image description here

Answer

Your data is being truncated because it exceeds the 255 byte limit of a tinytext column. You'll need to use a column type that supports more data:

      Type | Maximum length
-----------+-------------------------------------
  TINYTEXT |           255 (2 8−1) bytes
      TEXT |        65,535 (216−1) bytes = 64 KiB
MEDIUMTEXT |    16,777,215 (224−1) bytes = 16 MiB
  LONGTEXT | 4,294,967,295 (232−1) bytes =  4 GiB

(from TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes)