On 14/12/2018 19:20, Kalle Sommer Nielsen wrote:
Den fre. 14. dec. 2018 kl. 16.54 skrev Lester Caine <[email protected]>:

On 14/12/2018 14:20, Peter Kokot wrote:
Log:
Trim trailing whitespaces

It is worth mentioning that the trailing space in SQL is often inserted
to ensure that there IS a space between the various elements. Although
'strip' to compact the query string before transmission will probably be
used here.

The new line feed act as a space between the multi line SQL query.

Early strip processing removed the various options of 'new line' but replacing them with a single space was not necessarily the right answer, which is why many scripts have a manual space at the end of each line of text. Just explaining why those spaces had originally been the correct coding style. There has been a debate recently on extending from an 80 character line default, and stripping line feeds to pad out a longer line length may well need these spaces reinstating ... just a matter of preferred coding style when working with SQL rather than other scripts.

--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk

--
PHP Webmaster List Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to