Skip to Content.
Sympa Menu

freetds - Re: [freetds] Escape sequences on output data

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Escape sequences on output data
  • Date: Tue, 20 Mar 2018 09:50:06 +0000

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




Archive powered by MHonArc 2.6.24.

Top of Page