> Did you know that this does not convert your data to dialect 3? It only changes the dialect flag on the header...but in future you will have a mixture of D1 and D3 data in your tables, i.e., unrecoverably inconsistent data.
>
> The only condition where it is "safe" to do this is where you have a totally empty database, e.g., you have restored a metadata-only backup and you are going to pump the data from the original database into it after modifying the dialect flag.
>
> The rest - as DS indicated.
>

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

How to change dialect to databases in production 24x7?

What inconsistent data is unrecoverably?

I thought that the changes of dialect are only language and data types, but not the data itself.

Jesus