At 03:22 AM 25/01/2008, you wrote:

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

Something is...

>what could be a workaround?

Provide the *exact* code you are using in your SP, including the declarations, the character set[s] of the database and the variables, and also which Firebird version you are using.

./heLen