Informix - ALLOW_NEWLINE
I understand how ALLOW_NEWLINE works. However, I don't understand why this option is there in the first place. I would have thought that having it on a consistent basis would be more useful than not. Then you can control when you want newlines to appear by inserting "\ n" into your code.
Can anyone explain why this option is there? Is this a more expensive process to turn on?
a source to share
There are several reasons:
-
The SQL standard does not allow newlines in the middle of lines - you have to work moderately hard to get a newline in the SQL string.
-
For most people, in most cases, a newline on a line indicates an error — a forgotten matching quote.
Hence, the default gets closer to the standard and prevents obfuscation of silly typos. However, if there is no other way to get newlines into character strings, this function is necessary.
a source to share