Ad

October CMS - Data Too Long For Column 'content' At Row 1

- 1 answer

I have an error saving a field to the database, which is giving me the error: String data, right truncated: 1406 Data too long for column 'content' at row 1.

However the field in the database is set to Type: String, length 191. Which i believe translates to varchar.

Anybody else had this?

Ad

Answer

You should NOT store a posts or pages content (something that contains a lot of text/html) as String.

Instead use TEXT for the MySQL column type, which allows to enter enough characters in there.

Ad
source: stackoverflow.com
Ad