Subject Query on SQL Dialects
Author MuraliM
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]