Speaking to the limitations of file system sizes alone:
FAT12 has a 32MB file size limit
FAT16 has a 2GB file size limit
FAT32 has a 4GB file size limit
NTFS has a 16EiB file size limit
EXT3 has a 2TB file size limit

I believe the "Firebird limit" on database size depends on the page
size set when you create the database. I definitely have some
Firebird databases that are over 2GB.

I've also read that with an 8K page size you can have BLOB's up to
32GB, so that would imply to me that databases could be at least that
large. Perhaps someone can provide you with an exact answer from the
Firebird side. However, do consider the info above when choosing a
file system.

Luke

--- In firebird-support@yahoogroups.com, "Hardy Sherwood" <HardyS@...>
wrote:

>
> I understand that there is a 2GB limit on Firebird database.
>
>
>
> I'd appreciate if you let me know whether this is correct?
>
>
>
> I'm running Firebird under windows. Does this limit apply to all file
> formats, that is FAT16, FAT32, NTFS?
>
>
>
> Hardy Sherwood
>
> 801 429-2153
>
>
>
>
>

-----------------------------------------------------------------------------------

> This message and contents are confidential and intended solely for
> the use of the individual or entity to whom they are addressed. If you
> have received this email in error please notify the system manager.
>
> The original email message has been scanned for computer viruses.
>

-----------------------------------------------------------------------------------

>
>
>
> [Non-text portions of this message have been removed]
>