Hi,

we're currently migrating our java project from sybase to firebird.
We now have trouble with char(n) columns - Sybase returned values
with trailing whitespace stripped off while Firebird returns the
values padded to n chars.

e.g. let name be a column of typ char(10):

select name from person
(Sybase) -> "Duke"
(Firebird)-> "Duke______" (_ meaning whitespace)

Can somebody give me a suggestion how to handle this?

Should I change all columns from char to varchar or is there a
general switch that I could use (preferred)?

Thanks

Sven