Hi all,We are migrating our application from Interbase 5.6 to Firebird 1.5.4. In the process we took a backup of Interbase db which had \'Dialect\' setting as 1,this backup db was restored for Firebird with the same setting(Dialect 1).After doing this, few tables which had fields with Interbase datatype \'Date\' got its datatype changed to \'Timestamp\' in Firebird and few fields were also set default value as \'1-jan-100\' for \'TimeStamp\' type. However, in Firebird db with setting \'Dialect 1\' we were not able to add any fields with datatype \'Time\' or \'TimeStamp\', only \'Date\' type was available. If we set the Dialect as 3 in Firebird, all \'Date\',\'Time\' and \'Timestamp\' are available.
Doubt on our part is, why the datatype for fields having interbase \'Date\' type is changed to type \'Timestamp\' when \'Dialect 1\' (which does not support \'TimeStamp\' datatype) is set for the Firebird db.
Please clarify.

[Non-text portions of this message have been removed]