Bug #87820 Workbench omitting new lines in OSX
Submitted: 21 Sep 2017 0:14 Modified: 5 Oct 2017 6:19
Reporter: Kevin Art Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.9 OS:MacOS (Sierra 10.12.6 )
Assigned to: CPU Architecture:Any

[21 Sep 2017 0:14] Kevin Art
Description:
We have markdown content including line breaks stored in a `mediumtext` column, character set utf8. MySQL Workbench does not show any line breaks under OSX. 
The same version of MySQL Workbench (6.3.9) running under Ubuntu shows the line breaks.

Screenshots here: https://imgur.com/a/842Gj
osx top, ubuntu bottom.

Cheers

How to repeat:
create a table with mediumtext column, insert document with line breaks, select under osx and ubuntu.
[21 Sep 2017 0:21] Kevin Art
mysql on the console shows line breaks.
[21 Sep 2017 8:21] MySQL Verification Team
Hello Kevin Art,

Thank you for the report and feedback!

Thanks,
Umesh
[5 Oct 2017 6:19] Mike Lischke
Showing multiline text in the result grid has been the source of quite some grief in the past and we hence changed the display to single line only. There is the form view (second icon in the right hand menu bar) which allows to view content record-by-record and also shows multiline text properly. Use that for viewing + editing such content.

It's more of an oversight that on Linux the result grid still shows multiple lines per cell.