Line breaks being stripped out of returned result sets

(2 posts) (2 voices)
  1. wattsm, Member


    I have a query that can return a long text field and I would like to use line breaks to break up the results, but the line break does not seem to be present in the result set in mydbr.

    I do not see any line breaks when running the below in mydbr, but I do when run in MySQL Workbench:

    SELECT 'some text without a line break' AS 'line';

    SELECT 'some text with a return
    there' AS 'line';

    SELECT 'some text with a new line char \n there' AS 'line';

    Is there a way to get the line breaks to show in mydbr?


  2. myDBR Team, Key Master

    By default, HTML renders line breaks as spaces. If you wish to keep the line breaks you can apply a CSS rule for it.

    myDBR Team


You must log in to post.