14.11.2019 03:40, Richard Damon richard@... [firebird-support] wrote:

> By the SQL standard, there are some noticeable effects. CHAR is defined
> as a fixed width, so data is padded with blanks to reach that width, and
> then the blanks are removed on retrieval.
>
> Firebird might not implement this distinction since it doesn't need to
> pad CHAR fields.

Firebird doesn't implement trim on retrieval but padding is unavoidable.

--
WBR, SD.