Subject Problem with columns too big
Author phil_hhn
Hi, I have a database I've been using for a long time under FB1.5 and UnicodeFSS (var)chars. Because of the UnicodeFSS, I'm mindful that I'm dealing with multi-byte chars.

When I process my schema to create this database under Firebird 2.5.2, and using UTF8 for all my (var)chars, for one create table statement I get the error:
"GDS Exception. 335544351. unsuccessful metadata update new record size of 79948 bytes is too big..."
(The query executes ok but gives this error when I call commit.)

I have checked all my columns and calculated the max size that should be required:
8 Integer columns: 32 bytes
4 char columns, 150 chars total: 450 bytes
13 varchar columns, 19812 chars total: 59436 bytes
4 timestamp columns, 32 bytes.

So by my calculations, this comes to 59950 bytes; within the 64k Firebird limit.

So have I gone wrong in my calculations somewhere, or is there something else at play here? As I mentioned earlier, this works ok with UnicodeFSS/Firebird 1.5.

Thanks in advance, Phil