|Subject||Re: [firebird-support] Help With External Table Issue|
look for CHR(13)+CHR(10) at the end of lines
open external table with editor (I use textpad) is good for big data.
El Jueves, 11 de septiembre, 2014 20:14:24, "'Edward Mendez' Emendez001@... [firebird-support]" <email@example.com> escribió:
I think I found out why I am having the problem.
I found release notes on Firebird 2.5 and saw this following…
Large External Table Support Enabled
Previous Firebird versions used 32-bit I/O when working with external tables, limiting the size of the external
file to < 2 GB. The mechanism has been enhanced to use 64-bit I/O on filesystems that support it, effectively
eliminating the 2 GB limit.
Tracker reference CORE-2492.
So I am guessing that even though FB 2.1.4 DB is 64bit architecture, it is still using the 32 bit I/O for external Tables.
I was able to verify that this works well in FB 2.5.3.