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

How can we tell if you don't show us the code that raises this error?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com