https://bugs.documentfoundation.org/show_bug.cgi?id=70433
--- Comment #14 from Tamas Bunth <[email protected]> ---
As I see, the result is an empty Clob right now, because the getClob() function
in Resultset.cxx returns always a nullpointer. (not implemented).
Before Julien's patch, the type received from getColumnTypeFromFBType (in
Util.cxx) was the type of a blob, instead of clob. That's why the result was
"OBJECT" before, instead of and empty cell.
This experiment makes me assume, that the UI could display a non-empty clob (or
text-Blob in case of Firebird, whatever) properly.
So we have two opportunities:
- Implement the XClob interface just as XBlob is implemented, and use it in
getClob():
https://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/XClob.html
- Use list with an extra CAST():
SELECT CAST (LIST( "Vorname", ' and ' ) as VARCHAR(32000) ) FROM
"Name_VarcharID"
That should work. At least it works for me.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
