[freetds] Testing charset

Frediano Ziglio freddyz77 at tin.it
Wed May 7 16:00:37 EDT 2003


I'm trying some query with tsql from RH8.
Query from "selct bug" mail seem to be converted correctly... perhaps
cause I use ssh or cause I'm using RH8 and not RH9 ??

See this query on tsql 

$ ./src/apps/tsql -S**** -Usa
locale is "en_US.UTF-8"
charset is "UTF-8"
Password: 
Msg 5703, Level 0, State 1, Server ****, Line 0
Changed language setting to us_english.
1> select nchar(0x41)
2> go
	
	
1> select nchar(65)
2> go
Msg 20019, Level 7, State 0, Server OpenClient, Line 1
Attempt to initiate a new SQL Server operation with results pending.
tds_submit_query() failed
1> bye

2003-05-07 21:58:37.787518 tds_put_string wrote 38 bytes
Sending packet @ 2003-05-07 21:58:37.787540
0000 01 01 00 2e 00 00 01 00-73 00 65 00 6c 00 65 00 |........ s.e.l.e.|
0010 63 00 74 00 20 00 6e 00-63 00 68 00 61 00 72 00 |c.t. .n. c.h.a.r.|
0020 28 00 30 00 78 00 34 00-31 00 29 00 0a 00       |(.0.x.4. 1.)...|


Received header @ 2003-05-07 21:58:37.789462
0000 04 01 00 21 00 37 01 00-                        |...!.7..|


Received packet @ 2003-05-07 21:58:37.789505
0000 81 01 00 00 00 01 00 ef-02 00 00 d1 02 00 41 00 |........ ......A.|
0010 fd 10 00 c1 00 01 00 00-00                      |........ .|


2003-05-07 21:58:37.789540 processing result tokens.  marker is 
81(TDS7_RESULT)2003-05-07 21:58:37.789597 tds7_get_data_info:1279: 
        type = 47 (char)
        column_varint_size = 2
        colname =  (0 bytes)
        column_size = 1 (2 on server)

         ^^^^^^^^^^^^^^^ this sounds strange... it should be 3

2003-05-07 21:58:37.789805 processing result tokens.  marker is  d1(ROW)
2003-05-07 21:58:37.789853 processing row tokens.  marker is  d1(ROW)
2003-05-07 21:58:37.789872 processing row.  column is 0 varint size = 2
2003-05-07 21:58:37.789889 processing row.  column size is 2 
2003-05-07 21:58:37.789944 clearing column 0 NULL bit
2003-05-07 21:58:37.790097 processing row tokens.  marker is  41()
2003-05-07 21:58:37.790133 inside tds_process_default_tokens() marker is
41()
Unknown marker: 65(41)!!
2003-05-07 21:58:37.790159 processing result tokens.  marker is  0()
2003-05-07 21:58:37.790175 inside tds_process_default_tokens() marker is
0()
Unknown marker: 0(0)!!
tds_submit_query(): state is PENDING

freddy77





More information about the FreeTDS mailing list