Subject Re: [firebird-support] Firebird 2 multiple DB files?
Author Helen Borrie
At 10:17 AM 18/03/2008, Fidel Viegas wrote:
>On Mon, Mar 17, 2008 at 10:25 PM, Anderson Farias
><peixedragao@...> wrote:
>
>> It was not quite wrong also. Try creating a DB with more than 4Gb using IB6
>> on WinXP and you're going to get an error/corruption, even the OS
>> supporting
>> files over 4Gb.
>
>I haven't really used IB6 with files of that size. If that is the
>case, then yes, it wasn't quite wrong also.
>But, generally speaking, the limitations are found in the file system
>itself.

Correct.

>You may find some softwares, like video capture softwares that
>split the file when it reaches the 4GB limit. This to avoid file
>corruption. I would expect IB6 to work properly in an NTFS file
>system.

It did. But there is NTFS and NTFS. The NTFS that was implemented for NT4 has the 4 Gb limit. People upgrade the OS and mistakenly think that it upgrades their partition formats. It doesn't. I still have some NT 4 NTFS disks around here. And it's surprising also how often we find databases on FAT32 partitions. ;-)

>Is this a bug in IB6?

No, not guilty.

>What causes this to happen?

Human error. :-)

./hb