freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: crawford charles <fiducianettestz AT yahoo.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] New Sybase datatype?
- Date: Wed, 14 Mar 2007 11:44:50 -0700 (PDT)
Hi,
I believe I have encountered a new (to me anyway)
datatype. The value is 0x7B, and it looks like it
could be similar to a INTN (0x26) or FLTN (0x6d)
from its form.
I searched the 3.6 and 3.8 Sybase TD Functional spec,
and the FreeTDS 0.64 code base and documentation. I'd
appreciate any help.
the packet contains a "TDS_BUF_NORMAL".
The buffer contains DBRPC (0xE6), PARAMFMT (0x20)
and PARAMS (0xD7) tokens.
the PARAMFMT token has two parameter definitions
both have the datatype id is 0x7b.
There is one byte following the datatype (08), in the
PARAMFMT2 which make me think it might be similar to a
INTN, UINTN or FLTN.
The fact that the PARAMS values look like it they
might
be "smaller" than the maxiumum size:
04 18 98 00 00 = size = 04, value = 18 98 00 00
00 = size = 00 value = NULL
An editted/commented ethereal "data bytes" trace
follows.
Any ideas?
Thanks.
0030 xx xx xx xx xx xx 0f 01 ........
^ "BUF_NORMAL" header
0038 00 44 00 00 01 00 e6 13 .D......
^DBRPC token
0040 00 10 xx xx xx xx xx xx ..xxxxxx
16 character RPC name
0048 xx xx xx xx xx xx xx xx xxxxxxxx
0050 xx xx 02 00 20 1a 00 00 xx.. ...
^optns^ PARAMFMT2:
0058 00 02 00 00 01 00 00 00 ........
^## ##^NL^ status ^
## ## = parameter count
NL = parameter name length
0060 00 00 00 00 7b 08 00 00 ....{...
^ user type ^?? LL^NL^
LL = locale length
0068 01 00 00 00 00 00 00 00 ........
^ status ^ user type
0070 7b 08 00 d7 04 18 98 00 {.......
^?? LL^PARAMS
0078 00 00 ....
____________________________________________________________________________________
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/features_spam.html
-
[freetds] MS SQL Query for "Output Parameters (0xAC 172)" response token,
Shama Dhume, 03/13/2007
-
Re: [freetds] MS SQL Query for "Output Parameters (0xAC 172)" responsetoken,
ZIGLIO, Frediano, VF-IT, 03/13/2007
-
[freetds] New Sybase datatype?,
crawford charles, 03/14/2007
-
Re: [freetds] New Sybase datatype?,
James K. Lowden, 03/14/2007
-
Re: [freetds] New Sybase datatype?,
ZIGLIO, Frediano, VF-IT, 03/15/2007
-
Re: [freetds] New Sybase datatype?,
crawford charles, 03/15/2007
- Re: [freetds] New Sybase datatype?, ZIGLIO, Frediano, VF-IT, 03/15/2007
-
Re: [freetds] New Sybase datatype?,
crawford charles, 03/15/2007
-
Re: [freetds] New Sybase datatype?,
ZIGLIO, Frediano, VF-IT, 03/16/2007
-
[freetds] Requested: Clarification about TEXT type (0x23) on SqlServer,
crawford charles, 03/30/2007
-
Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer,
James K. Lowden, 03/31/2007
- Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer, crawford charles, 03/31/2007
- Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer, James K. Lowden, 03/31/2007
-
Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer,
James K. Lowden, 03/31/2007
-
[freetds] Requested: Clarification about TEXT type (0x23) on SqlServer,
crawford charles, 03/30/2007
-
Re: [freetds] New Sybase datatype?,
ZIGLIO, Frediano, VF-IT, 03/15/2007
-
Re: [freetds] New Sybase datatype?,
James K. Lowden, 03/14/2007
-
[freetds] New Sybase datatype?,
crawford charles, 03/14/2007
-
Re: [freetds] MS SQL Query for "Output Parameters (0xAC 172)" responsetoken,
ZIGLIO, Frediano, VF-IT, 03/13/2007
Archive powered by MHonArc 2.6.24.