Change sql dialects in firebird database

cmd

C:\Program Files (x86)\Firebird\Firebird_2_1\bin>gfix.exe -sql_dialect 1 c:\data\db\production.fdb
Database dialect being changed from 3 to 1

C:\Program Files (x86)\Firebird\Firebird_2_1\bin>gfix.exe -sql_dialect 3 c:\data\db\production.fdb

gistfile1.txt

https://github.com/rowland/activerecord-fb-adapter/issues/6

http://firebirdsql.org/manual/gfix-dialect.html

http://www.firebirdsql.org/manual/isql-connect.html

SQL

Use CONNECT or CREATE DATABASE to specify a database
SQL> CONNECT C:\data\db\production.fdb;
Database:  C:\data\db\production.fdb
SQL> show sql dialect;
        Client SQL dialect is set to: 3 and database SQL dialect is: 3
SQL> set sql dialect 2
CON> show sql dialect;
WARNING: Client SQL dialect has been set to 2 when connecting to Database SQL dialect 3 database.
SQL> set sql dialect 1;
WARNING: Client SQL dialect has been set to 1 when connecting to Database SQL dialect 3 database.
SQL> set sql dialect 1;
WARNING: Client SQL dialect has been set to 1 when connecting to Database SQL dialect 3 database.
SQL>