[Libreoffice-bugs] [Bug 117115] New: Firebird: migration from HSQLDB does not respect language-specific characters

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117115

            Bug ID: 117115
           Summary: Firebird: migration from HSQLDB does not respect
                    language-specific characters
           Product: LibreOffice
           Version: 6.1.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gerhard.weydt at t-online.de

When migrating an existing database document with HSQLDB to Firebird
language-specific characters in field names are not transferred correctly. For
example, german "ß" is changed to "/u00df", its unicode equivalent, in the
_name_ of the field.
his is not a problem of Firebird, and not even of Firebird within LibreOffice,
you can create fields with names using language-specific characters, they are
saved correctly and are reproduced when opening the document; I've tested it.
So that's a deficiency in the migration program.
I will add test documents: a database document with one table, having (except
for the first, which is simply an id) field names consisting of one generally
used latin character and one language-specific: "?" and the three german
Umlaute and three french (and partly Italian ...) characters, "a" with the
three accents. And the result after the migration to Firebird.
These are examples of language-specific characters easily available on my
keyboard. For all those the unicode representation is used for the name in
Firebird, which certainly is a problem - if not a catastroph - for all programs
using that table, because all references to these fields do not work.
This is a grave problem, because for non-european languages there are lots of
those non-latin characters, which must be migrated correctly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180419/77046eae/attachment.html>