Skip to Content.
Sympa Menu

freetds - RE: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works onSQL 2K

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works onSQL 2K
  • Date: Tue, 23 Sep 2003 11:32:40 +0200

> > >
> > > I still can't log in with tsql, because charset
> > > name "646" doesn't map to ASCII anymore ...
> > >
> >
> > Fixed in CVS (some days ago)
>
> I can connect now, thanks. But what do you make of this dump?
>
> Starting log file for FreeTDS 0.62.dev.20030723
> on 2003-09-18 16:15:56 with debug level 99.
> names for ISO-8859-1: ISO-8859-1
> names for UTF-8: UTF-8
> names for UCS-2LE: UCS-2LE
> names for UCS-2BE: UCS-2BE
> iconv to convert client-side data to the "646" character set
> ^^^ fine
> 16:15:56.426874 tds_iconv_info_init: converting "UCS-4LE"->"UCS-2LE"
> ^^^^^^^ huh?
> 16:15:56.427043 tds_iconv_info_init: converting
> "ISO-8859-1"->"UCS-2LE"
> 16:15:56.427184 Connecting to 10.80.58.175 port 2500, TDS 7.0.
> ...
>

I modified src/tds/common.c (setting 646 charset instead of
ISO-8859-1... why we set a default charset ?? Perhaps we should remove
this line... also we should detect correct system charset in tds, not
only using tsql...)

I got

Starting log file for FreeTDS 0.62.dev.20030923
on 2003-09-23 11:26:56 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "646" character set
11:26:56.501891 tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
11:26:56.502078 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
11:26:56.502161 Connecting to 10.1.36.114 port 1433, TDS 7.0.

Seem correct (I used latest snapshot, still problems with my ISP...)
Check your src/tds/encoding.h file.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page