Subject Re: [firebird-support] ODS 9
Author Helen Borrie
At 06:52 AM 10/02/2007, you wrote:
>Hi all,
>Is there a version of Firebird that can read an ODS 9 database?

Yes, all versions can *=read=* an ODS 9 database, provided the access
is done via a Dialect 1 client. Even Fb 2.0 still supports the
Dialect 1 client.

Firebird 1.0 and 1.5.x can also (theoretically) perform "native"
writes to an IB 5.x database in response to requests from a Dialect 1
client. However, you are likely to bump into incompatibilities and
data inconsistencies if you depend on this. The latter-day engines
recognise the old data formats but they apply their own, later rules
in calculations.

As a simple example, in ODS 9, an integer/integer expression would
return a 32-bit double precision result, whereas ODS 10 and higher
return an integer . ODS 9 1/3 returns 0.333333.... whereas ODS 10+ return 0.