Hello,

If you backup your ib56 database with Interbase and restore it with
Firebird, dialect is preserved, so you can stay with dialect 1.
With Firebird 2, dialect 1 is still available.
for datatypes, the major difference between 1 and 3 is the DATE
type : in dialect 1, its a timestamp type but in dialect 3, its a
DATE type and you have TIME or if you want the equivalent TIMESTAMP.
for conversion, it depends on number of stored procedures, tables,
etc... dialect 3 is evolving with firebird versions but dialect 1 is
legacy.

Regards

Alexandre

--- In IB-Conversions@yahoogroups.com, "MuraliM "
<muralim_firebird@...> wrote:

>
> Hi,One quick question on SQL Dialects. We are migrating from

Interbase 5.6 to Firebird 1.5.4.I understand that Interbase 5.6
support SQL Dialect 1 and Firebird 1.5.4 supports both SQL Dialect 1
& SQL Dialect 3, but by default the SQL Dialect is set to SQL
Dialect 3.Because of this SQL Dialect setting, the double quotes
are not allowed in Firebird as they are delimited identifiers.Will
there be any problems if we set the SQL Dialect to 1 in Firebird
1.5.4? We are thinking to set the SQL Dialect to 1 so that double
quotes used in our queries need not be changed to single
quotes.Suppose we choose SQL Dialect as 1 and in future we wanted to
move to Firebird 2, what will be the impact?Thanks

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