Created attachment 203443 [details]
Extract, connect database file to *.odb-file and open with different LO-versions.

Download the attached zip file.
There are 2 element: A *.odb-file, which connects to an external Firebird database file.
The first command for this external Firebird file was

ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION UNICODE

To set right sorting for Germany. The internal sorting of Firebird wthout setting to UTF8 is useless …

Connect this files by Edit → Database → Properties → Advanced Properties → Browse
If you created this connection you could see with LO up to LO 24.2.5.2 2 tables in the tables pane, both containing 1 row.
If you connect with LO 24.8.0.3 an newer version you couldn't see any tables.

Try to input values in this "non existent" tables through Tools → SQL:
INSERT INTO "tbl_Town" ("ID","Town") VALUES ('2','Berlin')

You will get an error:
firebird_sdbc error:
*COLLATION UNICODE for CHARACTER SET UTF8 is not installed
caused by
'isc_dsql_prepare'

Same error appears if you try to add a new table in the tables pane by using GUI.

It is impossible to work with such a database when using LO 24.8.0.3 or newer. Users might think they have lost all data, all tables - but the data are there…

This buggy behavior appears on Windows 10, Windows 11 and also OpenSUSE 15.6 on different machines.