Bug #87820 Workbench omitting new lines in OSX

• Submitted: 21 Sep 2017 0:14
• Modified: 5 Oct 2017 6:19
• Reporter: Kevin Art
• Status: Won't fix
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.3.9
• OS: MacOS (Sierra 10.12.6 )
• 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.