[freetds] SQL Server version and TDS Version
vinhdizzo at gmail.com
Mon Apr 19 10:55:49 EDT 2010
> On Apr 18, 2010, at 3:47 PM, James K. Lowden wrote:
> > Vinh Nguyen wrote:
> >> Sure, here is a TDSDUMP when I specify TDS version 8:
> >> log.c:190:Starting log file for FreeTDS 0.82
> >> on 2010-04-18 12:42:52 with debug flags 0x4fff.
> >> iconv.c:197:names for ISO-8859-1: ISO-8859-1
> >> iconv.c:197:names for UTF-8: UTF-8
> >> iconv.c:197:names for UCS-2LE: UCS-2LE
> >> iconv.c:197:names for UCS-2BE: UCS-2BE
> >> iconv.c:363:iconv to convert client-side data to the "utf-8"
> >> character
> >> set iconv.c:432:tds_iconv_info_init: client charset name ""
> >> unrecognized
> > That doesn't look good. Are you using OS X's iconv(3)? It looks
> > like it
> > wants the name in upper case. (Cf. line 197.)
$ which iconv
based upon the location, iconv came from Macports. Should I be using
> > I think FreeTDS doesn't know the encoding, decides it's "probably" ISO
> > 8859-1 (wrongly) and mis-encodes something in your login packet,
> > causing
> > the server to reject it.
> Here are the options I see for Mac OS X (Leopard PPC, if it matters):
> % iconv -l | grep -i utf\.8
> UTF-8 UTF8
> UTF-8-MAC UTF8-MAC
> So the question probably is who or what thinks it wants utf-8 rather
> than UTF-8? If that setting came from a freetds.conf, the answer is
> easy -- don't do that. If it's a default chosen by FreeTDS, that
> surprises me because I though all of the common mappings had long
> since been worked out.
I'm on snow leopard intel and I get:
~$ iconv -l | grep -i utf\.8
I'm not familiar with the iconv stuff, so it shouldn't be showing
UTF-8? What then should it be? Any suggestions on a fix? Can I
specify a in freetds.conf?
More information about the FreeTDS