Subject | Re: [ib-support] Eliminate need for trim() |
---|---|
Author | Lucas Franzen |
Post date | 2003-04-30T19:08:18Z |
David,
hay77772000 schrieb:
Use a VARCHAR field instead.
CHAR fields will always be padded, VARCHAR not.
Luc.
hay77772000 schrieb:
>Yes.
> 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?
Use a VARCHAR field instead.
CHAR fields will always be padded, VARCHAR not.
Luc.