Thanks for your fast reply! I've been at least a bit lucky: the record structure of the data I want to recover is simple and I already found how to detect a record and decode all the other fields (a varchar which always store a 17 chars string and two integers). The database is in ODS 11 format and the field is DECIMAL(18,4). Comparing with some data I have from an old backup, I've noticed that when the value is zero it is stored as two bytes (0xE7 0x00), otherwise the value always seems to be encoded with eight bytes with the first equal to 0xEF.
2011/7/26 Dmitry Yemanov <firebi...@yandex.ru>: > 26.07.2011 16:00, Alessandro Fiorino wrote: > >> Can someone point me to where can I found in the source how a DECIMAL >> field is encoded when saved on disk ? >> I need it to manually recover a broken database. > > It depends on its declared precision and database dialect. > > Also, you're unlikely to detect some particular field on disk, as the > record is RLE compressed as a whole, so you'd need to find the record > and unpack it before accessing fields. > > > Dmitry > > ------------------------------------------------------------------------------ > Magic Quadrant for Content-Aware Data Loss Prevention > Research study explores the data loss prevention market. Includes in-depth > analysis on the changes within the DLP market, and the criteria used to > evaluate the strengths and weaknesses of these DLP solutions. > http://www.accelacomm.com/jaw/sfnl/114/51385063/ > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > > > ------------------------------------------------------------------------------ Magic Quadrant for Content-Aware Data Loss Prevention Research study explores the data loss prevention market. Includes in-depth analysis on the changes within the DLP market, and the criteria used to evaluate the strengths and weaknesses of these DLP solutions. http://www.accelacomm.com/jaw/sfnl/114/51385063/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
