Hi, from http://www.ibphoenix.com/resources/documents/general/doc_323



Maximum row size for user tables - 64KB.Count bytes. BLOB and ARRAY 
columns each cost 8 bytes to store the ID; VARCHARs, byte length + 
2;CHARs, byte-length; SMALLINT, 2; INTEGER, FLOAT, DATE and TIME, 4; 
BIGINT, DOUBLE PRECISION and TIMESTAMP, 8; NUMERIC and DECIMAL, 4 or 8, 
depending on precision.

Regards

Pablo Sánchez

On 10/5/18 1:42 PM, m_brahi...@yahoo.fr [firebird-support] wrote:
> Hello,
> 
> I need to know please, what is the limit of record in a table with more 
> than a hundred fields in FB 3 without reaching the 64 KB maximum row 
> size. How many records my table must contains ?
> 
> Sorry if my question seems lazy.
> 
> Thanks
> 
> 
> 
> 

  • [firebird-support] ... m_brahi...@yahoo.fr [firebird-support]
    • [firebird-supp... pablo sanchez pab...@adinet.com.uy [firebird-support]
    • Re: [firebird-... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]

Reply via email to