laravel eloquent write new line in varchar

Question

I want to add data to a table cell that contains a line break.

INSERT INTO someTable (data) VALUES ("111\n222");

When I view it in mysql workbench it displays as: "111 222"

Doing it with eloquent writes "111\n222" to the table:

 $someTable = new SomeTable;
 $someTable->data = implode('\n', $dataArray);
 $someTable->save();

I.e. workbench displays "111\n222" instead of the actual new line.

meda · Accepted Answer · 2017-04-06 20:07:46Z

4

Change single quote to double quotes:

 $someTable->data = implode("\n", $dataArray);

answered Apr 6, 2017 at 20:07

meda

45.5k14 gold badges96 silver badges123 bronze badges

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

1 Answer 1