[freetds] select bug...
sioakim at atlas.ace-hellas.gr
Tue May 13 04:37:25 EDT 2003
> Special for you today, if ibiblio's not back online already:
OK got it!
Starting log file for FreeTDS 0.62.dev.20030513
on 2003-05-13 11:02:26 with debug level 99.
iconv to convert client-side data to the "ISO-8859-7" character set
11:02:26.244776 tds_iconv_info_init: client charset name "ISO-8859-7"
11:02:26.244806 Connecting to 192.168.2.253 port 1433, TDS 7.0.
11:02:26.245102 tds_put_string converting 19 bytes of
11:02:26.245121 tds_put_string converting 19 bytes of
As you can see the difference is that the charset is unrecognized for
> > 1. iconv --version
> > iconv (GNU libc) 2.3.2
> I don't know what to make of that. Does "iconv -l |grep
> 8859-*7" (that's
> a lowercase -l, as in "--list") show anything?
#iconv -l |grep 8859-*7
> > 2. Maybe you haven't realised the complications of a brand
> new release
> > like Redhat 9 :-P
> You're kidding, right? Are you on RH8? Because that's a
> UTF-8 setup.
No its not RH8 it's RH9 (even worse).
So yes it does support utf8 but I'm not using utf8. If change
LANG="en_US.UTF-8" tsql does fire up as a UTF-8 client.
> > make iso-8859-7.bin
> > g++ -O2 -g -o make_charset make_charset.cpp
> > make_charset.cpp: In function `int main(int, char**)':
> > make_charset.cpp:14: `string' undeclared (first use this function)
> These and subsequent errors stem from not having your -I set
> up to find
> your C++ header files. You could adjust according to:
> $ find /usr/include -name string
> or look in the same directory as the tarball for my copy of
> the .bin file.
Ok finally got it to work but I defined codepoint and name as char (512)
cause I couldn't get the string to work.
[root at atlas iconv]# hexdump -C iso-8859-7.bin |grep -i f0
000000a0 e6 e7 e8 e9 ea eb ec ed ee ef f0 f1 f2 f3 f4 f5
|ζηθικλμνξοπρςστυ| <---- correctly displayed greek characters
[root at atlas iconv]# printf "%x\n" $(expr 2 \* `printf "%d\n" 0xaa`)
[root at atlas iconv]# iconv -f iso-8859-7 -t UCS-2LE iso-8859-7.bin \
> |hexdump |grep -i 03C0
0000150 03be 03bf 03c0 03c1 03c2 03c3 03c4 03c5
As far as I can see I get exactly the same results as you do.
More information about the FreeTDS