Data too long for column for longtext datatype - MySqlException

3 votes

1 answer

12944 views

                          I am trying to insert string in LONGTEXT column. Length of string is 75402 and byte count is 150804 (about 147 KB)

Throws an exception Data too long for column On inserting record. 

MySQL document state that LONGTEXT can contains maximum 4GB of data

Any suggestion will be welcome

**UPDATE:**

Exception occurs when characters length is greater than 65535

But 65536 is a max length of TEXT datatype and I am using LONGTEXT here.

Asked by Munavvar (131 rep)

Dec 13, 2016, 06:33 AM
Last activity: Aug 31, 2019, 09:00 PM

Data too long for column for longtext datatype - MySqlException

Related Questions