Hello All,



We are trying to replace our Borland data-access library with FireBird.
During our experiment we found that FireBird is returning char fields with
trailing spaces (which is exactly how char field is suppose to work).



The problem is, Borland use to right trim the trailing spaces, and all of
our current code is written in that fashion.



I know there are few options like putting TRIM in all the code or by
changing char type to varchar.



But I was wondering if I can do some configuration that will automatically
handle trimming without modifying any of our existing code.



Any help in this regard is highly appreciated.



Thanks,

Rahil





[Non-text portions of this message have been removed]