Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] [ freetds-Patches-731907 ]Choosingdatalengthwhenbinding fixed types
  • Date: Mon, 5 May 2003 14:48:01 +0200

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page