Hi,
I am trying to connect to a MSSQL database via the tds_fdw
extension. I've installed the extension version 1.0.8 from BIGSQL
on a Windows machine.
I get a client charset invalid though, and I'm not sure where it
is set or what to set it to:
config.c:886:Setting tds version to 7.3 (0x703).
config.c:788:TDS version set to 7.3 from $TDSVER.
config.c:765:Setting 'dump_file' to 'C:\temp\freetds.log'
from $TDSDUMP.
dblib.c:1237:tdsdbopen: Calling
tds_connect_and_login(00000000003DF9D0, 00000000003BE2B0)
iconv.c:328:tds_iconv_open(00000000003DF9D0,
CP1252;LC_CTYPE=English_United
States.1252;LC_MONETARY=C;LC_NUMERIC=C;LC_TIME=C)
iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
iconv.c:187:local name for UTF-8 is UTF-8
iconv.c:187:local name for UCS-2LE is UCS-2LE
iconv.c:187:local name for UCS-2BE is UCS-2BE
iconv.c:346:setting up conversions for client charset
"CP1252;LC_CTYPE=English_United
States.1252;LC_MONETARY=C;LC_NUMERIC=C;LC_TIME=C"
iconv.c:348:preparing iconv for
"CP1252;LC_CTYPE=English_United
States.1252;LC_MONETARY=C;LC_NUMERIC=C;LC_TIME=C" <->
"UCS-2LE" conversion
iconv.c:423:tds_iconv_info_init: client charset name
"-1" invalid
It looks like the error comes form
https://github.com/wankdanker/freetds/blob/master/src/tds/iconv.c#L424
I believe that I can set the "client charset" in a .freetds.conf
file, but I'm not sure what to set it to since CP1252 seems very
valid. Or perhaps it should be set to "CP1252" only without the
Locale information afterwards?
Any ideas?
Thanks,
