<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Datatype Binary(fix) [CHAR] couldn't be filled with content"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125957">bug 125957</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">See Also</td>
<td>
</td>
<td>https://bugs.documentfoundation.org/show_bug.cgi?id=104734
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>btomi96@gmail.com, lionel@mamane.lu, miguelangelrv@libreoffice.org, serval2412@yahoo.fr
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Datatype Binary(fix) [CHAR] couldn't be filled with content"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125957#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Datatype Binary(fix) [CHAR] couldn't be filled with content"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125957">bug 125957</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>On pc Debian x86-64 with master sources updated today, I could reproduce this.
This type has been added with this block:
865 // Binary (CHAR)
866 // It is distinguished from Text type by its character set
867 aRow[1] = new ORowSetValueDecorator(OUString("CHAR"));
868 aRow[2] = new ORowSetValueDecorator(DataType::BINARY);
869 aRow[3] = new ORowSetValueDecorator(sal_Int16(32765)); //
Prevision = max length
870 aRow[6] = new ORowSetValueDecorator(OUString("length")); //
Create Params
871 aRow[9] = new ORowSetValueDecorator(
872 sal_Int16(ColumnSearch::NONE)); // Searchable
873 aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum
scale
874 aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max
scale
875 tmp.push_back(aRow);
See
<a href="https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/DatabaseMetaData.cxx?r=572c9db0#865">https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/DatabaseMetaData.cxx?r=572c9db0#865</a>
in commit
<a href="https://cgit.freedesktop.org/libreoffice/core/commit/?id=bf662904c4b60e93c6b86e06288d41996eed12a2">https://cgit.freedesktop.org/libreoffice/core/commit/?id=bf662904c4b60e93c6b86e06288d41996eed12a2</a>
author Tamas Bunth <<a href="mailto:tamas.bunth@collabora.co.uk">tamas.bunth@collabora.co.uk</a>> 2017-12-16 12:57:43
+0100
committer Tamás Bunth <<a href="mailto:btomi96@gmail.com">btomi96@gmail.com</a>> 2017-12-28 10:39:48 +0100
commit bf662904c4b60e93c6b86e06288d41996eed12a2 (patch)
tree e3508e2504a07622559793393fcbc19023157bfd
parent 3c567e55e6aed9e0da892d8b9fc09f8a0c784fcc (diff)
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - FIREBIRD: Add those field types that are not available with FB while they are available with Hsqldb"
href="show_bug.cgi?id=104734">tdf#104734</a> Firebird: Add Binary (fix) type
There is no explicit binary type in Firebird. It can be accomplished
using the CHAR type with a special character set, which tells the
database that it is binary data and there is no collation. (called
OCTETS).
Because of that, we also need the character set to decide the exact
column type.
And also refactor some parts of the driver:
- Create class to determine internal type from firebird type, subtype,
scale and character set.
- Use internal type (DataType::XXX) in XDatabaseMetaData::getTypeInfo()
indirectly. (We want to return a Firebird type for each internal type,
not in the opposite direction.
I can remove the block but perhaps it should be fixed, in this case, I don't
know what should be done.
Lionel/Tamas: don't hesitate to share your thoughts about it.</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>