> On Nov 13, 2019, at 10:01 AM, Dimitry Sibiryakov s...@ibphoenix.com 
> [firebird-support] <firebird-support@yahoogroups.com> wrote:
> 
> 13.11.2019 15:51, blackfalconsoftw...@outlook.com [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
> 
> 
> 
        • [fi... blackfalconsoftw...@outlook.com [firebird-support]
        • Re:... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
        • [fi... blackfalconsoftw...@outlook.com [firebird-support]
        • Re:... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
        • Re:... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
        • Re:... blackfalconsoftw...@outlook.com [firebird-support]
        • Re:... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
        • Re:... blackfalconsoftw...@outlook.com [firebird-support]
        • Re:... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
        • Re:... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
    • Re: [firebi... Ann Harrison aharri...@ibphoenix.com [firebird-support]
  • Re: [firebird-su... Richard Damon rich...@damon-family.org [firebird-support]
    • Re: [firebi... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
    • [firebird-s... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
  • Re: [firebird-su... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
    • Re: [firebi... blackfalconsoftw...@outlook.com [firebird-support]
      • Re: [fi... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • Re: [fi... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]

Reply via email to