Skip to Content.
Sympa Menu

freetds - [freetds] Testing charset

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Testing charset
  • Date: Wed, 07 May 2003 20:00:37 -0000

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






Archive powered by MHonArc 2.6.24.

Top of Page