FreeTDS Development Group

["FlavianoMa" <FlavianoMa.software AT teseo.com>]

I have my SQL Server installed on Windows Xp in Polish.
When I connect from TDS I can't read correctly the Polish chars.
If I set client charset as ISO-8859-1 I received an error and the Polish
chars are translated in ?.
If I set client charset as UTF-8 I received the Polish chars as 2 byte
in my string.
If I set client charset as UCS-2LE or UCS-2BE I can't connect.
I use FreeTDS 0.62.4 and below the FreeTDS.LOG: the 1st is when I
connected with ISO-8859-1, the 2nd is when I connected with UTF-8

The correctly conversion for T_PATTNAME should be:
0x4F 0x42 0xA3 0x2E 0x20 0x50 0x52 0x5A 0x59 0x8C 0x52 0x2E 0x20 0x50
0x52 0x5A 0x45 0x44 0x4E 0x49 0x41 0x00

Thanks

***////////////////////////////////////////////////////ISO-8859-1///////
///////////////////////////////////////////////////////////****
Starting log file for FreeTDS 0.62
        on 2005-04-16 08:05:08 with debug level 99.
Using trivial iconv from
        iconv2.c
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: (null)
iconv to convert client-side data to the "ISO-8859-1" character set
08:05:08 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
08:05:08 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
08:05:08 Connecting to 172.27.0.113 port 1433, TDS 8.0.
08:05:08 tds_put_string converting 12 bytes of "xxx.xx.x.xxx"
08:05:08 tds_put_string wrote 24 bytes
08:05:08 tds_put_string converting 3 bytes of "xxx"
08:05:08 tds_put_string wrote 6 bytes
08:05:08 tds_put_string converting 13 bytes of "xxxxxxxxxxxxx"
08:05:08 tds_put_string wrote 26 bytes
08:05:08 tds_put_string converting 12 bytes of "xxx.xx.x.xxx"
08:05:08 tds_put_string wrote 24 bytes
08:05:08 tds_put_string converting 10 bytes of "DB-Library"
08:05:08 tds_put_string wrote 20 bytes
08:05:08 tds_put_string converting 10 bytes of "us_english"
08:05:08 tds_put_string wrote 20 bytes
08:05:08 tds_put_string wrote 0 bytes
08:05:08 tds_process_login_tokens()
Received header @ 08:05:09
0000 04 01 01 95 00 35 01 00-                        |.....5..|


Received packet @ 08:05:09
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 74 |..m.a.s. t.e.r..t|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d.  .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 0f 43 00 45 00-4c 00 53 00 49 00 55 00 |....C.E. L.S.I.U.|
0080 53 00 5f 00 58 00 50 00-50 00 5f 00 50 00 4f 00 |S._.X.P. P._.P.O.|
0090 4c 00 00 00 00 e3 08 00-07 05 15 04 d0 00 00 00 |L....... ........|
00a0 e3 17 00 02 0a 75 00 73-00 5f 00 65 00 6e 00 67 |.....u.s ._.e.n.g|
00b0 00 6c 00 69 00 73 00 68-00 00 ab 78 00 47 16 00 |.l.i.s.h ...x.G..|
00c0 00 01 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
00d0 00 64 00 20 00 6c 00 61-00 6e 00 67 00 75 00 61 |.d. .l.a .n.g.u.a|
00e0 00 67 00 65 00 20 00 73-00 65 00 74 00 74 00 69 |.g.e. .s .e.t.t.i|
00f0 00 6e 00 67 00 20 00 74-00 6f 00 20 00 75 00 73 |.n.g. .t .o. .u.s|
0100 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|
0110 00 2e 00 0f 43 00 45 00-4c 00 53 00 49 00 55 00 |....C.E. L.S.I.U.|
0120 53 00 5f 00 58 00 50 00-50 00 5f 00 50 00 4f 00 |S._.X.P. P._.P.O.|
0130 4c 00 00 00 00 ad 36 00-01 71 00 00 01 16 4d 00 |L.....6. .q....M.|
0140 69 00 63 00 72 00 6f 00-73 00 6f 00 66 00 74 00 |i.c.r.o. s.o.f.t.|
0150 20 00 53 00 51 00 4c 00-20 00 53 00 65 00 72 00 | .S.Q.L.  .S.e.r.|
0160 76 00 65 00 72 00 00 00-00 00 08 00 02 f8 e3 13 |v.e.r... ........|
0170 00 04 04 34 00 30 00 39-00 36 00 04 34 00 30 00 |...4.0.9 .6..4.0.|
0180 39 00 36 00 fd 00 00 00-00 00 00 00 00          |9.6..... .....|


08:05:09 looking for login token, got  e3(ENVCHANGE)
08:05:09 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 12 from wire to give 6 to client.
08:05:09 looking for login token, got  ab(INFO)
08:05:09 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 74 from wire to give 37 to client.
tds_get_string: reading 30 from wire to give 15 to client.
08:05:09 looking for login token, got  e3(ENVCHANGE)
08:05:09 tds_process_default_tokens() marker is e3(ENVCHANGE)
08:05:09 tds_iconv_info_init: use memcpy to convert
"ISO-8859-1"->"CP1250"
08:05:09 looking for login token, got  e3(ENVCHANGE)
08:05:09 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
08:05:09 looking for login token, got  ab(INFO)
08:05:09 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 30 from wire to give 15 to client.
08:05:09 looking for login token, got  ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
08:05:09 looking for login token, got  e3(ENVCHANGE)
08:05:09 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 8 from wire to give 4 to client.
08:05:09 increasing block size from 4096 to 4096
08:05:09 looking for login token, got  fd(DONE)
08:05:09 tds_process_default_tokens() marker is fd(DONE)
08:05:09 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
08:05:09 tds_process_end() state set to TDS_IDLE
08:05:09 leaving tds_process_login_tokens() returning 1
08:05:09 tds_put_string converting 19 bytes of "set textsize 64512 "
08:05:09 tds_put_string wrote 38 bytes
Sending packet @ 08:05:09
0000 01 01 00 2e 00 00 01 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00       | .6.4.5. 1.2. .|


Received header @ 08:05:09
0000 04 01 00 11 00 35 01 00-                        |.....5..|


Received packet @ 08:05:09
0000 fd 00 00 be 00 00 00 00-00                      |........ .|


08:05:09 processing result tokens.  marker is  fd(DONE)
08:05:09 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
08:05:09 tds_process_end() state set to TDS_IDLE
08:05:09 tds_process_result_tokens() state is COMPLETED
08:05:09 dbuse()
08:05:09 dbcmd() bufsz = 0
08:05:09 in dbsqlexec()
08:05:09 in dbsqlsend()
08:05:09 tds_put_string converting 8 bytes of "use METI"
08:05:09 tds_put_string wrote 16 bytes
Sending packet @ 08:05:09
0000 01 01 00 18 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|
0010 4d 00 45 00 54 00 49 00-                        |M.E.T.I.|


08:05:09 in dbsqlok()
Received header @ 08:05:09
0000 04 01 00 a9 00 35 01 00-                        |.....5..|


Received packet @ 08:05:09
0000 e3 17 00 01 04 4d 00 45-00 54 00 49 00 06 6d 00 |.....M.E .T.I..m.|
0010 61 00 73 00 74 00 65 00-72 00 ab 70 00 45 16 00 |a.s.t.e. r..p.E..|
0020 00 01 00 23 00 43 00 68-00 61 00 6e 00 67 00 65 |...#.C.h .a.n.g.e|
0030 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0040 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0050 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 4d |.x.t. .t .o. .'.M|
0060 00 45 00 54 00 49 00 27-00 2e 00 0f 43 00 45 00 |.E.T.I.' ....C.E.|
0070 4c 00 53 00 49 00 55 00-53 00 5f 00 58 00 50 00 |L.S.I.U. S._.X.P.|
0080 50 00 5f 00 50 00 4f 00-4c 00 00 01 00 e3 08 00 |P._.P.O. L.......|
0090 07 05 15 04 d0 00 00 00-fd 00 00 e2 00 00 00 00 |........ ........|
00a0 00                     -                        |.|


08:05:09 dbsqlok() marker is e3
08:05:09 processing result tokens.  marker is  e3(ENVCHANGE)
08:05:09 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 12 from wire to give 6 to client.
08:05:09 processing result tokens.  marker is  ab(INFO)
08:05:09 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 70 from wire to give 35 to client.
tds_get_string: reading 30 from wire to give 15 to client.
08:05:09 processing result tokens.  marker is  e3(ENVCHANGE)
08:05:09 tds_process_default_tokens() marker is e3(ENVCHANGE)
08:05:09 processing result tokens.  marker is  fd(DONE)
08:05:09 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
08:05:09 tds_process_end() state set to TDS_IDLE
08:05:09 dbsqlok() end status was success
08:05:09 dbresults()
08:05:09 dbresults_r()
08:05:09 tds_process_result_tokens() state is COMPLETED
08:05:09 leaving dbresults() returning 1
08:05:09 tds_process_row_tokens() state is COMPLETED
08:05:13 dbcmd() bufsz = 9
08:05:13 in dbfreebuf()
08:05:13 in dbsqlexec()
08:05:13 in dbsqlsend()
08:05:13 tds_put_string converting 49 bytes of "SELECT T_PATTNAME FROM
PATTERNS WHERE K_PATTID=88"
08:05:13 tds_put_string wrote 98 bytes
Sending packet @ 08:05:13
0000 01 01 00 6a 00 00 01 00-53 00 45 00 4c 00 45 00 |...j.... S.E.L.E.|
0010 43 00 54 00 20 00 54 00-5f 00 50 00 41 00 54 00 |C.T. .T. _.P.A.T.|
0020 54 00 4e 00 41 00 4d 00-45 00 20 00 46 00 52 00 |T.N.A.M. E. .F.R.|
0030 4f 00 4d 00 20 00 50 00-41 00 54 00 54 00 45 00 |O.M. .P. A.T.T.E.|
0040 52 00 4e 00 53 00 20 00-57 00 48 00 45 00 52 00 |R.N.S. . W.H.E.R.|
0050 45 00 20 00 4b 00 5f 00-50 00 41 00 54 00 54 00 |E. .K._. P.A.T.T.|
0060 49 00 44 00 3d 00 38 00-38 00                   |I.D.=.8. 8.|


08:05:13 in dbsqlok()
Received header @ 08:05:13
0000 04 01 00 62 00 35 01 00-                        |...b.5..|


Received packet @ 08:05:13
0000 81 01 00 00 00 09 00 e7-64 00 15 04 d0 00 00 0a |........ d.......|
0010 54 00 5f 00 50 00 41 00-54 00 54 00 4e 00 41 00 |T._.P.A. T.T.N.A.|
0020 4d 00 45 00 d1 2a 00 4f-00 42 00 41 01 2e 00 20 |M.E..*.O .B.A... |
0030 00 50 00 52 00 5a 00 59-00 5a 01 52 00 2e 00 20 |.P.R.Z.Y .Z.R... |
0040 00 50 00 52 00 5a 00 45-00 44 00 4e 00 49 00 41 |.P.R.Z.E .D.N.I.A|
0050 00 fd 10 00 c1 00 01 00-00 00                   |........ ..|


08:05:13 dbsqlok() marker is 81
08:05:13 dbsqlok() found result token
08:05:13 dbresults()
08:05:13 dbresults_r()
08:05:13 processing result tokens.  marker is  81(TDS7_RESULT)
08:05:13 adjust_character_column_size:
        Server charset: UCS-2LE
        Server column_size: 100
        Client charset: ISO-8859-1
        Client column_size: 50
tds_get_string: reading 20 from wire to give 10 to client.
08:05:13 tds7_get_data_info:1451:
        colname = T_PATTNAME (10 bytes)
        type = 39 (varchar)
        server's type = 231 (x UCS-2 varchar)
        column_varint_size = 2
        column_size = 50 (100 on server)
08:05:13 dbresults_r() result_type = 4049 retcode = 1
08:05:13 processing result tokens.  marker is  d1(ROW)
08:05:13 dbresults_r() result_type = 4040 retcode = 1
08:05:13 leaving dbresults() returning 1
08:05:20 dbbind() column = 1 1 0
08:05:20 dbbind() srctype = 39 desttype = 47
08:05:20 tds_willconvert()
08:05:20 tds_willconvert() 39 47 1
08:05:24 dbnextrow()
08:05:24 processing row tokens.  marker is  d1(ROW)
08:05:24 processing row.  column is 0 varint size = 2
08:05:24 processing row.  column size is 42
08:05:24 clearing column 0 NULL bit
08:05:24 tds_client_msg: #2403: "WARNING! Some character(s) could not be
converted into client's character set. Unconverted bytes were changed to
question marks ('?').".  Connection state is now 1.
08:05:24 dbconvert(39 [SYBVARCHAR] len 21 => 47 [SYBCHAR] len -2)
08:05:24 dbconvert() calling tds_convert
08:05:24 dbconvert() called tds_convert returned 21
08:05:24 dbconvert() outputting 21 bytes character data destlen = -2
08:05:24 leaving dbnextrow() returning -1
08:05:32 dbnextrow()
08:05:32 processing row tokens.  marker is  fd(DONE)
08:05:32 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 1
08:05:32 tds_process_end() state set to TDS_IDLE
08:05:32                  rows_affected = 1
08:05:32 leaving dbnextrow() returning -2
08:05:36 in dbfreebuf()

***//////////////////////////////////////////////////UTF-8//////////////
/////////////////////////////////////////////////****
Starting log file for FreeTDS 0.62
        on 2005-04-16 08:18:00 with debug level 99.
Using trivial iconv from
        iconv2.c
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: (null)
iconv to convert client-side data to the "UTF-8" character set
08:18:00 tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
08:18:00 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
08:18:00 Connecting to 172.27.0.113 port 1433, TDS 8.0.
08:18:00 tds_put_string converting 12 bytes of "xxx.xx.x.xx1"
08:18:00 tds_put_string wrote 24 bytes
08:18:00 tds_put_string converting 3 bytes of "xxx"
08:18:00 tds_put_string wrote 6 bytes
08:18:00 tds_put_string converting 13 bytes of "xxxxxxxxxxxxx"
08:18:00 tds_put_string wrote 26 bytes
08:18:00 tds_put_string converting 12 bytes of "xxx.xx.x.xxx"
08:18:00 tds_put_string wrote 24 bytes
08:18:00 tds_put_string converting 10 bytes of "DB-Library"
08:18:00 tds_put_string wrote 20 bytes
08:18:00 tds_put_string converting 10 bytes of "us_english"
08:18:00 tds_put_string wrote 20 bytes
08:18:00 tds_put_string wrote 0 bytes
08:18:00 tds_process_login_tokens()
Received header @ 08:18:00
0000 04 01 01 95 00 35 01 00-                        |.....5..|


Received packet @ 08:18:00
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 74 |..m.a.s. t.e.r..t|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d.  .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 0f 43 00 45 00-4c 00 53 00 49 00 55 00 |....C.E. L.S.I.U.|
0080 53 00 5f 00 58 00 50 00-50 00 5f 00 50 00 4f 00 |S._.X.P. P._.P.O.|
0090 4c 00 00 00 00 e3 08 00-07 05 15 04 d0 00 00 00 |L....... ........|
00a0 e3 17 00 02 0a 75 00 73-00 5f 00 65 00 6e 00 67 |.....u.s ._.e.n.g|
00b0 00 6c 00 69 00 73 00 68-00 00 ab 78 00 47 16 00 |.l.i.s.h ...x.G..|
00c0 00 01 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|
00d0 00 64 00 20 00 6c 00 61-00 6e 00 67 00 75 00 61 |.d. .l.a .n.g.u.a|
00e0 00 67 00 65 00 20 00 73-00 65 00 74 00 74 00 69 |.g.e. .s .e.t.t.i|
00f0 00 6e 00 67 00 20 00 74-00 6f 00 20 00 75 00 73 |.n.g. .t .o. .u.s|
0100 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|
0110 00 2e 00 0f 43 00 45 00-4c 00 53 00 49 00 55 00 |....C.E. L.S.I.U.|
0120 53 00 5f 00 58 00 50 00-50 00 5f 00 50 00 4f 00 |S._.X.P. P._.P.O.|
0130 4c 00 00 00 00 ad 36 00-01 71 00 00 01 16 4d 00 |L.....6. .q....M.|
0140 69 00 63 00 72 00 6f 00-73 00 6f 00 66 00 74 00 |i.c.r.o. s.o.f.t.|
0150 20 00 53 00 51 00 4c 00-20 00 53 00 65 00 72 00 | .S.Q.L.  .S.e.r.|
0160 76 00 65 00 72 00 00 00-00 00 08 00 02 f8 e3 13 |v.e.r... ........|
0170 00 04 04 34 00 30 00 39-00 36 00 04 34 00 30 00 |...4.0.9 .6..4.0.|
0180 39 00 36 00 fd 00 00 00-00 00 00 00 00          |9.6..... .....|


08:18:00 looking for login token, got  e3(ENVCHANGE)
08:18:00 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 12 from wire to give 6 to client.
tds_get_string: reading 12 from wire to give 6 to client.
08:18:00 looking for login token, got  ab(INFO)
08:18:00 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 74 from wire to give 37 to client.
tds_get_string: reading 30 from wire to give 15 to client.
08:18:00 looking for login token, got  e3(ENVCHANGE)
08:18:00 tds_process_default_tokens() marker is e3(ENVCHANGE)
08:18:00 tds_iconv_info_init: use memcpy to convert "UTF-8"->"CP1250"
08:18:00 looking for login token, got  e3(ENVCHANGE)
08:18:00 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
08:18:00 looking for login token, got  ab(INFO)
08:18:00 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 30 from wire to give 15 to client.
08:18:00 looking for login token, got  ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
08:18:00 looking for login token, got  e3(ENVCHANGE)
08:18:00 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 8 from wire to give 4 to client.
08:18:00 increasing block size from 4096 to 4096
08:18:00 looking for login token, got  fd(DONE)
08:18:00 tds_process_default_tokens() marker is fd(DONE)
08:18:00 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
08:18:00 tds_process_end() state set to TDS_IDLE
08:18:00 leaving tds_process_login_tokens() returning 1
08:18:00 tds_put_string converting 19 bytes of "set textsize 64512 "
08:18:00 tds_put_string wrote 38 bytes
Sending packet @ 08:18:00
0000 01 01 00 2e 00 00 01 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00       | .6.4.5. 1.2. .|


Received header @ 08:18:00
0000 04 01 00 11 00 35 01 00-                        |.....5..|


Received packet @ 08:18:00
0000 fd 00 00 be 00 00 00 00-00                      |........ .|


08:18:00 processing result tokens.  marker is  fd(DONE)
08:18:00 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
08:18:00 tds_process_end() state set to TDS_IDLE
08:18:00 tds_process_result_tokens() state is COMPLETED
08:18:00 dbuse()
08:18:00 dbcmd() bufsz = 0
08:18:00 in dbsqlexec()
08:18:00 in dbsqlsend()
08:18:00 tds_put_string converting 8 bytes of "use METI"
08:18:00 tds_put_string wrote 16 bytes
Sending packet @ 08:18:00
0000 01 01 00 18 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|
0010 4d 00 45 00 54 00 49 00-                        |M.E.T.I.|


08:18:00 in dbsqlok()
Received header @ 08:18:00
0000 04 01 00 a9 00 35 01 00-                        |.....5..|


Received packet @ 08:18:00
0000 e3 17 00 01 04 4d 00 45-00 54 00 49 00 06 6d 00 |.....M.E .T.I..m.|
0010 61 00 73 00 74 00 65 00-72 00 ab 70 00 45 16 00 |a.s.t.e. r..p.E..|
0020 00 01 00 23 00 43 00 68-00 61 00 6e 00 67 00 65 |...#.C.h .a.n.g.e|
0030 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0040 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0050 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 4d |.x.t. .t .o. .'.M|
0060 00 45 00 54 00 49 00 27-00 2e 00 0f 43 00 45 00 |.E.T.I.' ....C.E.|
0070 4c 00 53 00 49 00 55 00-53 00 5f 00 58 00 50 00 |L.S.I.U. S._.X.P.|
0080 50 00 5f 00 50 00 4f 00-4c 00 00 01 00 e3 08 00 |P._.P.O. L.......|
0090 07 05 15 04 d0 00 00 00-fd 00 00 e2 00 00 00 00 |........ ........|
00a0 00                     -                        |.|


08:18:00 dbsqlok() marker is e3
08:18:00 processing result tokens.  marker is  e3(ENVCHANGE)
08:18:00 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 12 from wire to give 6 to client.
08:18:00 processing result tokens.  marker is  ab(INFO)
08:18:00 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 70 from wire to give 35 to client.
tds_get_string: reading 30 from wire to give 15 to client.
08:18:00 processing result tokens.  marker is  e3(ENVCHANGE)
08:18:00 tds_process_default_tokens() marker is e3(ENVCHANGE)
08:18:00 processing result tokens.  marker is  fd(DONE)
08:18:00 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
08:18:00 tds_process_end() state set to TDS_IDLE
08:18:00 dbsqlok() end status was success
08:18:00 dbresults()
08:18:00 dbresults_r()
08:18:00 tds_process_result_tokens() state is COMPLETED
08:18:00 leaving dbresults() returning 1
08:18:00 tds_process_row_tokens() state is COMPLETED
08:18:03 dbcmd() bufsz = 9
08:18:03 in dbfreebuf()
08:18:03 in dbsqlexec()
08:18:03 in dbsqlsend()
08:18:03 tds_put_string converting 49 bytes of "SELECT T_PATTNAME FROM
PATTERNS WHERE K_PATTID=88"
08:18:03 tds_put_string wrote 98 bytes
Sending packet @ 08:18:03
0000 01 01 00 6a 00 00 01 00-53 00 45 00 4c 00 45 00 |...j.... S.E.L.E.|
0010 43 00 54 00 20 00 54 00-5f 00 50 00 41 00 54 00 |C.T. .T. _.P.A.T.|
0020 54 00 4e 00 41 00 4d 00-45 00 20 00 46 00 52 00 |T.N.A.M. E. .F.R.|
0030 4f 00 4d 00 20 00 50 00-41 00 54 00 54 00 45 00 |O.M. .P. A.T.T.E.|
0040 52 00 4e 00 53 00 20 00-57 00 48 00 45 00 52 00 |R.N.S. . W.H.E.R.|
0050 45 00 20 00 4b 00 5f 00-50 00 41 00 54 00 54 00 |E. .K._. P.A.T.T.|
0060 49 00 44 00 3d 00 38 00-38 00                   |I.D.=.8. 8.|


08:18:03 in dbsqlok()
Received header @ 08:18:03
0000 04 01 00 62 00 35 01 00-                        |...b.5..|


Received packet @ 08:18:03
0000 81 01 00 00 00 09 00 e7-64 00 15 04 d0 00 00 0a |........ d.......|
0010 54 00 5f 00 50 00 41 00-54 00 54 00 4e 00 41 00 |T._.P.A. T.T.N.A.|
0020 4d 00 45 00 d1 2a 00 4f-00 42 00 41 01 2e 00 20 |M.E..*.O .B.A... |
0030 00 50 00 52 00 5a 00 59-00 5a 01 52 00 2e 00 20 |.P.R.Z.Y .Z.R... |
0040 00 50 00 52 00 5a 00 45-00 44 00 4e 00 49 00 41 |.P.R.Z.E .D.N.I.A|
0050 00 fd 10 00 c1 00 01 00-00 00                   |........ ..|


08:18:03 dbsqlok() marker is 81
08:18:03 dbsqlok() found result token
08:18:03 dbresults()
08:18:03 dbresults_r()
08:18:03 processing result tokens.  marker is  81(TDS7_RESULT)
08:18:03 adjust_character_column_size:
        Server charset: UCS-2LE
        Server column_size: 100
        Client charset: UTF-8
        Client column_size: 200
tds_get_string: reading 20 from wire to give 10 to client.
08:18:03 tds7_get_data_info:1451:
        colname = T_PATTNAME (10 bytes)
        type = 39 (varchar)
        server's type = 231 (x UCS-2 varchar)
        column_varint_size = 2
        column_size = 200 (100 on server)
08:18:03 dbresults_r() result_type = 4049 retcode = 1
08:18:03 processing result tokens.  marker is  d1(ROW)
08:18:03 dbresults_r() result_type = 4040 retcode = 1
08:18:03 leaving dbresults() returning 1
08:18:08 dbbind() column = 1 1 0
08:18:08 dbbind() srctype = 39 desttype = 47
08:18:08 tds_willconvert()
08:18:08 tds_willconvert() 39 47 1
08:18:10 dbnextrow()
08:18:10 processing row tokens.  marker is  d1(ROW)
08:18:10 processing row.  column is 0 varint size = 2
08:18:10 processing row.  column size is 42
08:18:10 clearing column 0 NULL bit
08:18:10 dbconvert(39 [SYBVARCHAR] len 23 => 47 [SYBCHAR] len -2)
08:18:10 dbconvert() calling tds_convert
08:18:10 dbconvert() called tds_convert returned 23
08:18:10 dbconvert() outputting 23 bytes character data destlen = -2
08:18:10 leaving dbnextrow() returning -1
08:19:18 dbnextrow()
08:19:18 processing row tokens.  marker is  fd(DONE)
08:19:18 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 1
08:19:18 tds_process_end() state set to TDS_IDLE
08:19:18                  rows_affected = 1
08:19:18 leaving dbnextrow() returning -2
08:19:19 in dbfreebuf()
***/////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////****

Flaviano Maricotti
Software Department

----------------------------------------------------------------------------------------------
 
TESEO spa  via Agnelli 49  63023 FERMO (AP) ITALY   Tel. +39 0734 628818  
Fax. +39 0734 628816

software AT teseo.com      FlavianoMa.software AT teseo.com


DISCLAIMER. This electronic mail transmission may contain legally priviledge 
and/or confidential information. Do not read this if you are not the 
person(s) named.  Any use, distribution, copying or disclosure by any other 
person is stricly prohibited. If you received this trasmission in error 
destroy the original transmission and its attachments without reading or 
saving in any manner.
----------------------------------------------------------------------------------------------