Handle newline and carriage return in result data
When results from SQL query contain a newline/carriage return, only the first part of the result (until the first CR) is displayed.
For instance, if my DB field contains CR as follows :
My Business
1 park avenue
New-York
USA
When getting this field content through select, only the first line ("My Business") is displayed in the result panel.
1
vote
Myster
shared this idea
-
Myster
commented
Other example :
select 'Hello\n World' as TextWithCROnly returns "Hello".