Subject Re[4]: [ib-support] Port 3050 analysis tool
Author Carlos H. Cantu
I'm forwarding your message to FB-Devel so people there can check it
in the FB code.

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br (Firebird/Interbase HQ)

CIP> ----- Original Message -----
CIP> From: "Carlos H. Cantu"

>> This reminds me about the discussion about FAT varchars. Did someone
>> could verify that the varchars are really being transfered right
>> trimmed trought the network ?
>>
CIP> Apparently not only is it sent in full length, but the buffer is not
CIP> cleared.

CIP> select first 5 name from personel;
CIP> isql result:
CIP> NAME
CIP> ===============

CIP> ARDELEAN
CIP> ASZTALOS
CIP> BACSO
CIP> BALAJ
CIP> BALOGH


CIP> the field is 15varchar lenght

CIP> with tcp expert:

CIP> ## 20:54:31:734 Channel 1; DATA (Server -> Client): Length= 172
CIP> 00 00 00 42 00 00 00 00 00 00 00 01 08 00 41 52 B AR
CIP> 44 45 4C 45 41 4E 00 00 00 00 00 00 00 00 00 00 DELEAN
CIP> 00 00 00 42 00 00 00 00 00 00 00 01 08 00 41 53 B AS
CIP> 5A 54 41 4C 4F 53 00 00 00 00 00 00 00 00 00 00 ZTALOS
CIP> 00 00 00 42 00 00 00 00 00 00 00 01 05 00 42 41 B BA
CIP> 43 53 4F 4C 4F 53 00 00 00 00 00 00 00 00 00 00 CSOLOS
CIP> 00 00 00 42 00 00 00 00 00 00 00 01 05 00 42 41 B BA
CIP> 4C 41 4A 4C 4F 53 00 00 00 00 00 00 00 00 00 00 LAJLOS
CIP> 00 00 00 42 00 00 00 00 00 00 00 01 06 00 42 41 B BA
CIP> 4C 4F 47 48 4F 53 00 00 00 00 00 00 00 00 00 00 LOGHOS
CIP> 00 00 00 42 00 00 00 64 00 00 00 00 B d

CIP> observe the length is written (08, 08, 05, 05, 06) but is not blank
CIP> padded, instead the last name is left there.
CIP> BACSO is BACSOLOS (last 3 chars are from ASZTALOS)

CIP> Ciao,

CIP> Best regards,
CIP> Application Developer
CIP> Calin Iancu, Pirtea
CIP> S.C. SoftScape S.R.L.
CIP> pcalin@...



CIP> To unsubscribe from this group, send an email to:
CIP> ib-support-unsubscribe@egroups.com



CIP> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/