Nitin Jain Nitin Jain - 1 year ago 241
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 Source

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)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download