----- Original Message -----
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 ?
>
Apparently not only is it sent in full length, but the buffer is not
cleared.

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

ARDELEAN
ASZTALOS
BACSO
BALAJ
BALOGH


the field is 15varchar lenght

with tcp expert:

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

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

Ciao,

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