[freetds] SQLPrepare,
SQL Execute fails on SQL 7 but works onSQL 2K
ZIGLIO Frediano
Frediano.Ziglio at vodafone.com
Tue Sep 23 12:32:40 EDT 2003
> > >
> > > 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
More information about the FreeTDS
mailing list