From: | "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Invalid client charset when using TDS_FDW |
Date: | 2017-11-06 22:16:52 |
Message-ID: | 04a23bb0-3409-7112-f297-70991a42adc1@lucee.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
From | Date | Subject | |
---|---|---|---|
Next Message | Zarko Aleksic | 2017-11-06 22:52:47 | Re: the database system is shutting down - terminating walsender process due to replication timeout |
Previous Message | Rob Sargent | 2017-11-06 22:09:11 | Re: idle in transaction, why |