On 16-11-2019 09:33, jerz...@o2.pl [firebird-support] wrote: > >>> But only for FB 2.5, not for FB3! >>> My question was about FB3. Where is info about new versions? > >> In Release Notes for these versions. >> Maximum size of record was not changed. > > > This is a very big limitation, a few larger char fields with multibyte coding > and we get an exception. I don't understand why this limitation hasn't been > removed.
Because it is hard to do. A lot of internals in Firebird and its clients rely on this maximum size (hint: the number itself fits in a 2-byte unsigned integer). It is not like you just need to update a MAX_ROW_SIZE constant and it is changed. Consider that PostgreSQL has a limit of around 8KB (with its default page size). However, PostgreSQL has the advantage that variable length fields can be automatically stored out-of-line (ie basically as a blob, but that is transparent to the user). > And in FB4 it is also 64 kB? Yes. Mark -- Mark Rotteveel