Most hex encoded dumps have special programs to load the data back into the engine - I could not imagine anyone trying to use a straight sql script to handle any large datasets.
So the 64k limit would not apply On 19 November 2012 11:50, Dalton Calford <dalton.calf...@gmail.com> wrote: > Hex encoded - and with some engines, you can specify compressed (read > zlib) output. > > I have seen multiple different implementations of the extract > including some that use multiple different files in sub-directories, > while others extract to xml. > > It all depends upon the engine and the purpose of the dump in the first place. > > Most dumps are used with version control systems while others are used > for version upgrades. > > best regards > > Dalton > > On 19 November 2012 11:41, Alex Peshkoff <peshk...@mail.ru> wrote: >> On 11/19/12 20:22, Dimitry Sibiryakov wrote: >>> 19.11.2012 16:54, Ann Harrison wrote: >>>> Gbak is not equivalent to the MySQL or Postgres dumps which produce a >>>> series of insert >>>> statements that can be edited. >>> I wonder how they manage big BLOBs? >>> >> As far as I remember in hex, but you may try yourself. >> What can be said for sure - a series of insert statements is definitely >> not optimized for size, but certainly well compressable. >> >> >> ------------------------------------------------------------------------------ >> Monitor your physical, virtual and cloud infrastructure from a single >> web console. Get in-depth insight into apps, servers, databases, vmware, >> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >> Pricing starts from $795 for 25 servers or applications! >> http://p.sf.net/sfu/zoho_dev2dev_nov >> Firebird-Devel mailing list, web interface at >> https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
