<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Firebird: migration from HSQLDB does not respect language-specific characters"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117115">117115</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Firebird: migration from HSQLDB does not respect language-specific characters
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>gerhard.weydt@t-online.de
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>