Escape sequences on output data

Desmond Coertzen <[email protected]> Thu, 8 Mar 2018 14:14:09 +0200
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CALQ6=2A0zJaoK-1nBKo=5XevqtyQZba77TX_=fjAganTojTBcQ@mail.gmail.com>
Hi there,

I use freetds heavily to cart data backwards and forwards between mssql
systems and linux based systems. I have encountered a problem with mssql
character fields that contain control characters like tabs, CR, LF etc.
TSQL outputs these in raw format always. Is there -o options available
where escape sequences can be turned on or off?

I have gone far with replace and quotename functions built into the
queries, but it convoluted my scripts.I was hoping freetds has a built-in /
native solution to enable/disable escaping at will.

Thanks.