Laravel trying to save HTML in database

Question

I have a Laravel app which manages articles. These articles have a content section, which is being stored within the database as string (varchar). It worked properly when I did not put in some big content, but now it says:

String data, right truncated: 1406 Data too long for column 'content' at row 1

How am I supposed to store the content in the database as HTML?

user7744592 · Accepted Answer · 2017-12-10 13:40:48Z

5

Laravel supports the text, mediumText and longText column types which resolve to the respective MySQL equivalent.

An appropriate migration entry for your instance would be:

$table->text('content');

answered Dec 10, 2017 at 13:40

user7744592

Sign up to request clarification or add additional context in comments.

2 Comments

Agil Over a year ago

Perfect. I tottaly forgot about them although I used it in my older projects. Thanks

Agil Over a year ago

By the way, do not forget that text() field cannot be NULL, so nullable() will throw an exception.

Community · Accepted Answer · 2020-03-11 14:39:03Z

2

You need to expand the size of the content column in the database. This means change the type from varchar to text.

edited Mar 11, 2020 at 14:39

CommunityBot

11 silver badge

answered Dec 10, 2017 at 13:33

Thamer

1,9442 gold badges13 silver badges21 bronze badges

Collectives™ on Stack Overflow

Laravel trying to save HTML in database

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related