> Then why let FB change dialect of a database if it makes data inconsistent?

This is inherited behavior from Interbase.

> How to change dialect to databases in production 24x7?

During planned maintenance downtime or using replication.

SY, SD.