[freetds] [ freetds-Patches-731907 ]Choosingdatalengthwhenbinding fixed types

ZIGLIO Frediano Frediano.Ziglio at vodafoneomnitel.it
Mon May 5 08:48:01 EDT 2003


> 
> Hi there..
> 
> According to mssql 7.0 and 8.0 documentation, their varchar 
> supports up
> to 4K bytes. I don't know about Sybase.
> 
> Here's the TDSDUMP log generated when I ran a php page that didn't do
> anything but call the stored procedure. It starts at line 139
> (dbrpcinit). This should go through as the log is little over 
> 12kb. The
> recieved packet is at line 182.
> 
> Arnar
> 

>From dump

0000  03 01 02 4b 00 00 01 00  16 00 73 00 70 00 5f 00   |...K.... .s.p._.|

Why character dump do not print some characters ? Wrong isprint implementation ? What's your platform ?

0010  73 00 61 00 76 00 65 00  5f 00 70 00 65 00 72 00   |s.a.v.e. _.p.e.r.|
0020  73 00 69 00 73 00 74 00  65 00 6e 00 74 00 64 00   |s.i.s.t. e.n.t.d.|
0030  61 00 74 00 61 00 00 00  05 40 00 64 00 61 00 74   |a.t.a... @.d.a.t|
0040  00 61 00 00 27 04 04 59  54 6f 78 4f 6e 74 7a 4f   |.a..'..Y ToxOntzO|

27 04 04... FreeTDS it's trying to use old varchar (limited to 255), this is the problem...

0050  6a 59 36 49 6e 4a 6c 59  32 56 75 64 43 49 37 59   |jY6InJlY 2VudCI7Y|
0060  54 6f 31 4f 6e 74 7a 4f  6a 45 31 4f 69 4a 42 63   |To1OntzO jE1OiJBc|
0070  6d 35 68 63 69 42 43 61  58 4a 6e 61 58 4e 7a 62   |m5hciBCa XJnaXNzb|

freddy77



More information about the FreeTDS mailing list