Answering to a realy old message... The problem is that cayenne uses
RTRIM() on char-columns in a query.

Our database uses char(1) one some status columns. Should we switch to
varchar(1)? We also have som columns with char(8) that is a id that
always is 8 chars long. No trailing spaces. It seems a bit wasted to
use varchar on these fields. What do you guys think?