Cannot insert very long text in long text field

Question

When I insert a very long text in a long text field, Drupal shows this error:

Data too long

This field is allocated for articles in a content type, so I am sure the data will not be longer than some extent, but when the number of characters is almost more than 30000, it shows the error. Is there any default limitation on it?

The exception I get is the following one:

PDOException: SQLSTATE[HY000]: General error: 1406 Data too long for column 'source' at row 1: INSERT INTO {locales_source} (location, version, source, context, textgroup) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4);

Answer 1

Maximum theoretical data length in this database column is 4'294'967'299 characters (less than 2³²)

It is also limited by:

The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers.

"Data too long" is a MySQL error message, not Drupal one, so you need to re-configure your MySQL if you want to allow longer texts in body (or any other field)., as described in MySQL documentation.