FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2018-03-08 12:14 GMT+00:00 Desmond Coertzen <patrolliekaptein AT 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?
>

No, there's no option, column data are just printed.
Currently you can use complicated terminators.
Or propose an option/patch.

> 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.

Frediano