Klement Guenther - Munich-MR - external wrote:

> Why are trailing blanks ignored within varchars?
> I think this should only apply to data types with fixed length eg. CHAR.
> Is this a bug?

No, this is a standard behaviour in Firebird and many other databases
(including MySQL).

But yes, sometimes I need CHAR/VARCHAR to store exactly all the bytes
that I give it (including nulls, trailing blanks, etc). In that case you
need to do some encoding/escaping.

--
dave