If I remember correctly, TIMESTAMP in dialect 3 is the same as DATE in dialect 1. Dialect 1 does not have anything equivalent to TIME and DATE in dialect 3.

Any particular reason you do not want to upgrade to dialect 3 (can it be any harder than upgrading from Firebird 1.5 to Firebird 2.1, the only thing I can think of is that you have to do backup/restore to upgrade dialect, you don't have to do that to upgrade from 1.5 to 2.1)?

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of bausufm
Sent: 25. februar 2010 09:32
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Upgrading from FB 1.5 to 2.1 with SQL-Dialect 1

No one?

--- In firebird-support@yahoogroups.com, "bausufm" <bausufm@...> wrote:
>
> Hi,
> we are using Firebird 1.5 with SQL-Dialect 1.
> We have several thousand databases at our customers.
>
> Do we have any advantage upgrading to Firebird 2.1 using SQl-Dialect 1?
> Do we have better performance?
> can we use any new Feature of 2.1?
> Can we use Monitoring tables in Dialect 1?
> Can we upgrade databases in a backup/restore cycle?
> Is datatype timestamp available in Dialect 1?
> Other Advantages/disadvantages?
>
> Regards
> Falko