I am working with LibreOffice 188.8.131.52.
Libre Office base (Linux/Ubuntu): Version: 184.108.40.206
OS: Linux 4.15; UI-Render: Standard; VCL: gtk3;
language German (de_DE.UTF-8)]
I connect to an existing Firebird 3.0 database via the sdbc driver (direct connection, no jdbc or odbc). Connection string/database path: “file:///home/…/Databasename.fdb”. My firebird database is encoded in ISO8859_1 (“Western”, 8-bit charset), whereas my LibreOffice encodes in UTF-8.
Unfortunately, LibreOffice cannot read the special characters of the database (in German: the Umlauts). Instead it produces the question marks in black diamonds. It obviously does not translate between the ISO8859_1 charset of the database and its own UTF-8 charset.
Comment: With LibreOffice 5.x I had to connect via the JDBC driver (JAVA) to the database. More tedious to set up! But I could add “?encoding=ISO8859_1” to the connections string/database path and it would decode correctly. However, this does not work now.
How can I make it decode the ISO8859_1 character set correctly with the new sdbc connection? Or do I have to go back to the JAVA connection? I’d like to keep the new sdbc-connection, as it is easy to establish (no JAVA drivers necessary) and it is fast.
Thanks for an answer!