How to maximize the row size in laravel | mysql

Question

I want to max the size of the row description. I already set size to 10240 but still it shows error. how to store data in this column because i have to save large amount of data

 public function up()
{
    Schema::create('final_news', function (Blueprint $table) {
        $table->id();
        $table->integer('id_newspaper');
        $table->string('heading');
        $table->string('description', 10240);
        $table->timestamps();
    });
}

ERROR I GET

 SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 (SQL: insert into `final_news` (`id_newspaper`, `heading`, `d

escription, updated_at, created_at`)

Change it to `text` type maybe? `$table->text('description');` — user3532758, Jun 04 '21 at 11:21
I feel like you should read this: https://stackoverflow.com/questions/13506832/what-is-the-mysql-varchar-max-size — user3532758, Jun 04 '21 at 11:53

score 7 · Accepted Answer · answered Jun 04 '21 at 11:22

7

if string is long you can use longtext

  $table->longText('description')

The longText method creates a LONGTEXT equivalent column:

Ref:https://laravel.com/docs/8.x/migrations#column-method-longText

answered Jun 04 '21 at 11:22

John Lobo

14,355
2
10
20

2

MySQL's `LONGTEXT` has a size limit of 4GB. – Rick James Jun 05 '21 at 21:47
@RickJames.THanks for letting us know – John Lobo Jun 06 '21 at 01:59

How to maximize the row size in laravel | mysql

1 Answers1