Re: [Firebird-devel] Fields in data pages

2014-12-01 Thread Ann Harrison
Simon, > > Not to be rude or anything, but does FirstAID Extractor decrypt all types of > BLOBs? Firebird, like InterBase, has a mechanism for translation among blob formats called blob filters. There is a filter that translates the RDB$DESCRIPTOR format to a readable format. Isql, the util

Re: [Firebird-devel] Fields in data pages

2014-12-01 Thread supp...@ibknowledgebase.com
Stuart, It does not show BLOBs in preview, but during export - yes - it supports Firebird BLOBs and "small BLOBs" introduced in recent Interbase versions. Regards, Alexey Kovyazin IBSurgeon Not to be rude or anything, but does FirstAID Extractor decrypt all types of BLOBs? On Mon, Dec 1, 2

Re: [Firebird-devel] Fields in data pages

2014-12-01 Thread Stuart Simon
Not to be rude or anything, but does FirstAID Extractor decrypt all types of BLOBs? On Mon, Dec 1, 2014 at 2:17 AM, supp...@ibknowledgebase.com < supp...@ibknowledgebase.com> wrote: > Hi Stuart, > > Download FirstAID from www.ib-aid.com, run FirstAID Extractor and open > your database. It "decry

Re: [Firebird-devel] Fields in data pages

2014-12-01 Thread supp...@ibknowledgebase.com
Hi Stuart, Download FirstAID from www.ib-aid.com, run FirstAID Extractor and open your database. It "decrypts" data from Firebird database using its internal structures and shows you the values of fields in tables' records. Regards, Alexey Kovyazin IBSurgeon OK, but version numbers tell me

Re: [Firebird-devel] Fields in data pages

2014-11-30 Thread Stuart Simon
Thank you. In my RDB$FORMATS table, I have a single record. The RDB$RELATION_ID field is equal to 128, and the RDB$FORMAT field is equal to 1. But what I really want to know is, can you help me extract the data from the RDB$DESCRIPTOR field, which is a BLOB? I got to extract information about the f

Re: [Firebird-devel] Fields in data pages

2014-11-30 Thread Ann Harrison
sorrry, late tired. first name 20, not 23 Cheers, Ann > On Nov 30, 2014, at 8:38 PM, Ann Harrison wrote: > > > >> On Nov 30, 2014, at 6:35 PM, Stuart Simon wrote: >> >> OK, but version numbers tell me nothing. What I am looking for is an >> explanation of how Firebird (the package) can

Re: [Firebird-devel] Fields in data pages

2014-11-30 Thread Adriano dos Santos Fernandes
http://www.firebirdsql.org/manual/fb-internals.html Adriano -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity

Re: [Firebird-devel] Fields in data pages

2014-11-30 Thread Ann Harrison
> On Nov 30, 2014, at 6:35 PM, Stuart Simon wrote: > > OK, but version numbers tell me nothing. What I am looking for is an > explanation of how Firebird (the package) can tell which bytes belong to > which fields. Somehow Firebird must be able to tell the difference between > the following

Re: [Firebird-devel] Fields in data pages

2014-11-30 Thread Stuart Simon
OK, but version numbers tell me nothing. What I am looking for is an explanation of how Firebird (the package) can tell which bytes belong to which fields. Somehow Firebird must be able to tell the difference between the following two records: FirstName LastName 'Jim' 'Starkey' '

Re: [Firebird-devel] Fields in data pages

2014-11-30 Thread James Starkey
No for all questions. The record is a) run length encoded and b) contains a format version number that must be looked up in rdb$formats. On Sunday, November 30, 2014, Stuart Simon wrote: > > > On Sunday, November 30, 2014, Stuart Simon > wrote: > >> Hello Firebird Developers: >> Pardon me, bu

Re: [Firebird-devel] Fields in data pages

2014-11-30 Thread Dimitry Sibiryakov
30.11.2014 9:07, Stuart Simon wrote: > 1. Is there a field (e.g., "fp_field_type") in the field or record header > that would > indicate the field type? No. > 2. What indicates the end (or, alternatively, size in bytes) of a non-final > field in a > record with two or more fields? Nothin