[freetds] funny envchange packet

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Thu Jul 6 02:39:20 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?  
> 

No, as codepage is quite strange. However is quite strange cause usually
charset is encoded as string... perhaps is the id in master..syscharsets
table?
You should try to install mssql with different encoding...

freddy77




More information about the FreeTDS mailing list