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