The concatenatin problem is obviously a bug.
i have a field varchar(2056).
i have anaother field varchar(10) default '1234567890'.
i concatenate it to the first field.
i also control the length of the concatenation-result.
as soon as i come beyond the length of 255 (!) i get the error 'string
truncation'.
this is ovbiously a bug.
what could be a workaround?
regards, christoph