Subject Re: [ib-support] Eliminate need for trim()
Author Lucas Franzen
David,

hay77772000 schrieb:
>
> Hi. Still porting from mySQL...!
>
> Another difference (I should write a book!) is that Firebird seems
> to return the whole length of a Char field, whereas mySQL will trim
> any whitespace for you.
>
> Is there any setting to my Firebird do this too?

Yes.

Use a VARCHAR field instead.

CHAR fields will always be padded, VARCHAR not.

Luc.