[freetds] select bug...

Spyros Ioakim 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:
> 
> http://www.schemamania.org/projects/freetds/src/tds/iconv/free
> tds-0.62.dev.20030513.tar.gz

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"
unrecognized
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
"atlas.ace-hellas.gr"
11:02:26.245121 tds_put_string converting 19 bytes of
"atlas.ace-hellas.gr"
.
.

As you can see the difference is that the charset is unrecognized for
some reason.

> > 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
ISO-8859-7//
ISO8859-7//
ISO88597//
ISO_8859-7//
ISO_8859-7:1987//


> > 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).
#cat /etc/sysconfig/i18n
LANG="en_US"
SUPPORTED="en_US.UTF-8:en_US:en"
SYSFONT="latarcyrheb-sun16"

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
> 	/usr/include/g++/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`)
154
[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.

Thanks,
Spyros




More information about the FreeTDS mailing list