> On Nov 13, 2019, at 10:01 AM, Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
>
> 13.11.2019 15:51, blackfalconsoftware@... [firebird-support] wrote:
>> However, internally, the CHAR field definition is more efficient as the database does not
>> have to perform any field size calculations at the moment that data is being updated to a
>> VARCHAR field.
>
> No such calculations is performed in Firebird. Both CHAR and VARCHAR are always stored
> with full declared length.
>

In memory, yes. But the entire record will be compressed before being written to disk.

Good luck,

Ann

>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------
>
> Yahoo Groups Links
>
>
>