[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] Escape sequences on output data
From:       Frediano Ziglio <freddy77 () gmail ! com>
Date:       2018-03-20 9:50:06
Message-ID: CAHt6W4cmn-MNxeov0JALK4Jsvgvp51D4N5dLNOaRhYXwnF7ZZw () mail ! gmail ! com
[Download RAW message or body]

2018-03-08 12:14 GMT+00:00 Desmond Coertzen <patrolliekaptein@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
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
https://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]