How to change SQL dialect in database

If database was created with dialect 1 or 2 you can change it to 3 using IBConsole (Database/Properties/General/Database dialect+Apply)