If a quote contains new lines, they are displayed only when you edit the quote. In the display view, the new line is treated as a single space. However, when the quotes are delivered with the script on a website, the new line is ignored and therefore the last word of a line and the first word of the next line are merged incorrectly.
We need first a definition: Are new lines allowed or not? And second to be deleted and translated to spaces on create/edit or to be handled in showing quotes in the app and on the websites.
SELECT * FROM quotations WHERE quotation LIKE '%\n%'; returns actual 24 entries, e.g.
One more problem seen is \u000b (vertical tab) in quote ID 1359.
If a quote contains new lines, they are displayed only when you edit the quote. In the display view, the new line is treated as a single space. However, when the quotes are delivered with the script on a website, the new line is ignored and therefore the last word of a line and the first word of the next line are merged incorrectly.
We need first a definition: Are new lines allowed or not? And second to be deleted and translated to spaces on create/edit or to be handled in showing quotes in the app and on the websites.
SELECT * FROM
quotationsWHERE quotation LIKE '%\n%'; returns actual 24 entries, e.g.One more problem seen is \u000b (vertical tab) in quote ID 1359.