Created attachment 191891 [details]
Zip contains an external Firebird file and Base file, which connects to the same internal database file.

The attached package contains a database file "ohnecollviw.fdb", which has been created from an internal Firebird database under OpenSUSE Linux.
Connect this database file as external database to a Windows system.
There will be shown a table and a view in the tables folder.
Click on the view.
You will get an error:
COLLATION UNICODE for CHARACTER SET UTF8 is not installed. 

Code for the view ends with
…ORDER BY "Nachname" COLLATE UNICODE ASC.

Open the ODB-file "DB_ohne_Collation_View_Collation.odb". It's the file from which the external Firebird database file has been created.
Start the view. Could be started without any problem.

You could find the external database file in the temporary folder of your system. In windows it is always shown in upper cases: FIREBIRD.FDB.
You could copy this file and connect this external file to an external Firebird ODB-file. View starts without any problem.

When opening this extracted file under OpenSUSE you will get the same warning as you have got under Windows with the OpenSUSE file.

It isn't possible to use an extracted file from one system in another if COLLATION has been set. And COLLATION must be set to get the right order when sorting tables, so I set this before creating any table. Result: No table will be shown in other systems if I extracted the Firebird database file in my system.