Subject Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?
Author Mark Rotteveel
On 2019-11-13 15:51, blackfalconsoftware@... [firebird-support]
wrote:
> Thank you Anne, for your succinct comments regarding the differences
> between the efficiencies of a CHAR and VARCHAR field definitions.
>
> Human observation cannot actually elicit any observable effects
> between the two.
>
> 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. Again, this
> is not noticeable to a user unless the data that is being updated into
> a VARCHAR field is quite large.

Why are you trying to explain to Ann how Firebird works? Your
explanation is wrong, and Ann is intimately familiar with the internals
of Firebird and its predecessors as she was one of the original
developers of InterBase.

Mark