https://bugs.documentfoundation.org/show_bug.cgi?id=159155
Bug ID: 159155
Summary: FIREBIRD: Tables, created with "Set default
Collation…", couldn't be read in external database, if
database is used on other OS
Product: LibreOffice
Version: 24.2.0.1 rc
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 191891
--> https://bugs.documentfoundation.org/attachment.cgi?id=191891&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
