[freetds] funny envchange packet

Lowden, James K james.k.lowden at alliancebernstein.com
Wed Jul 5 17:48:40 EDT 2006


net.c:542:Received packet
0000 e3 21 00 01 09 67 00 6c-00 6f 00 62 00 61 00 6c |.!...g.l .o.b.a.l|
0010 00 73 00 69 00 6d 00 06-6d 00 61 00 73 00 74 00 |.s.i.m.. m.a.s.t.|
0020 65 00 72 00 ab 72 00 45-16 00 00 02 00 28 00 43 |e.r..r.E .....(.C|
0030 00 68 00 61 00 6e 00 67-00 65 00 64 00 20 00 64 |.h.a.n.g .e.d. .d|
0040 00 61 00 74 00 61 00 62-00 61 00 73 00 65 00 20 |.a.t.a.b .a.s.e. |
0050 00 63 00 6f 00 6e 00 74-00 65 00 78 00 74 00 20 |.c.o.n.t .e.x.t. |
0060 00 74 00 6f 00 20 00 27-00 67 00 6c 00 6f 00 62 |.t.o. .' .g.l.o.b|
0070 00 61 00 6c 00 73 00 69-00 6d 00 27 00 2e 00 0b |.a.l.s.i .m.'....|
0080 41 00 43 00 32 00 4b 00-41 00 4d 00 41 00 30 00 |A.C.2.K. A.M.A.0.|
0090 38 00 34 00 38 00 00 00-00 e3 17 00 02 0a 75 00 |8.4.8... ......u.|
00a0 73 00 5f 00 65 00 6e 00-67 00 6c 00 69 00 73 00 |s._.e.n. g.l.i.s.|
00b0 68 00 00 ab 70 00 47 16-00 00 01 00 27 00 43 00 |h...p.G. ....'.C.|
00c0 68 00 61 00 6e 00 67 00-65 00 64 00 20 00 6c 00 |h.a.n.g. e.d. .l.|
00d0 61 00 6e 00 67 00 75 00-61 00 67 00 65 00 20 00 |a.n.g.u. a.g.e. .|
00e0 73 00 65 00 74 00 74 00-69 00 6e 00 67 00 20 00 |s.e.t.t. i.n.g. .|
00f0 74 00 6f 00 20 00 75 00-73 00 5f 00 65 00 6e 00 |t.o. .u. s._.e.n.|
0100 67 00 6c 00 69 00 73 00-68 00 2e 00 0b 41 00 43 |g.l.i.s. h....A.C|
0110 00 32 00 4b 00 41 00 4d-00 41 00 30 00 38 00 34 |.2.K.A.M .A.0.8.4|
0120 00 38 00 00 00 00 
                       e3 0f-00 03 05 69 00 73 00 6f |.8...... ...i.s.o|
0130 00 5f 00 31 00 01 01 00
                            -e3 0b 00 05 04 31 00 30 |._.1.... .....1.0|
0140 00 33 00 33 00 00 e3 05-00 06 01 30 00 00 ad 36 |.3.3.... ...0...6|
0150 00 01 07 00 00 00 16 4d-00 69 00 63 00 72 00 6f |.......M .i.c.r.o|
0160 00 73 00 6f 00 66 00 74-00 20 00 53 00 51 00 4c |.s.o.f.t . .S.Q.L|
0170 00 20 00 53 00 65 00 72-00 76 00 65 00 72 00 00 |. .S.e.r .v.e.r..|
0180 00 00 00 08 00 08 72 e3-11 00 04 03 35 00 31 00 |......r. ....5.1.|
0190 32 00 04 34 00 30 00 39-00 36 00 fd 00 00 00 00 |2..4.0.9 .6......|
01a0 00 00 00 00                                     |....|

Here's my parsing of that ENVCHANGE packet:

e3	ENVCHANGE 
0f00 	15 bytes
03	TDS_ENV_CHARSET
05 	newval is 5 characters long
6900 7300 6f00 5f00 3100 
	iso_1
01	oldval is 1 character long
0100	^A ???

We discard the oldval in dblib, except to log it.  Maybe Microsoft is
sending a code page or something, instead of a name?  

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are
not the intended recipient, please contact the sender immediately by reply e-mail
and destroy all copies of the original message. Please note that we do not accept
account orders and/or instructions by e-mail, and therefore will not be responsible
for carrying out such orders and/or instructions.  If you, as the intended recipient
of this message, the purpose of which is to inform and update our clients, prospects
and consultants of developments relating to our services and products, would not
like to receive further e-mail correspondence from the sender, please "reply" to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New York,
NY 10105.



More information about the FreeTDS mailing list