Re: Disabling character translation

Frediano Ziglio <[email protected]> Tue, 8 Nov 2016 17:19:07 +0000
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAHt6W4e4hr917hkKBEa4X0Esm4RGaRV6kY_U2c6zLhWprEzLNA@mail.gmail.com>
2016-11-08 6:50 GMT+00:00 Peter Deacon <[email protected]>:
> Have data being shoveled into fields which do not represent native type
> reported by database and need to completely disable character translation.
>
> Looking for parity with SQL Server driver option "perform translation for
> character data" (ODBC.INI AutoTranslate=No)
>
> Anyone know of a trick to make it work?  Tried setting Charset in local
> environment using replacement iconv but every conversion in the list either
> crashed or didn't help.
>
> If not 'll send a patch to support it :)
>
> regards,
> Peter


Go on!
Just some details. libTDS can convert to multibyte (like utf-8)
directly. This is disabled by ODBC so using ODBC
libTDS just store data from network. Also usually conversion function
just copy data if char_conv is NULL.
There should be some conversion function in src/odbc directory to deal
with data conversion (I think metadata
like column names are all converted in all cases... I hope you don't
need these unconverted).

Frediano