Go to any table where a field has new lines in it. In my case it's varchar(8000).
Double click the table cell on that field.
The new lines are removed from the field, and clicking away from the field updates it with the new value. For example if you have this:
Hello World
Double clicking gives you a textarea with:
HelloWorld
This is because of PMA_getCellValue:
return $td.text();
All HTML is removed.
We have to find a way to replace <br / > by carriage return.
Last edit: Hugues Peccatte 2014-05-24
And then, in method showEditCell:
$(g.cEdit).find('.edit_box').val(value);
It seems that this line is also removing carriage returns… It will be easy…
Fix: https://github.com/phpmyadmin/phpmyadmin/pull/1193
This is still not fixed for me. If I double click a TEXT field, the line breaks are not there in the editable textarea. Currently using PMA 4.3.4.
Last edit: DisgruntledGoat 2015-01-02
A new PR has been sent: https://github.com/phpmyadmin/phpmyadmin/pull/1447
Hugues,
with your pull request, it's true that new lines are no longer removed; note that to enter a new line while grid editing, one has to use shift/enter and I wonder how we could publicize it.