https://bugs.freedesktop.org/show_bug.cgi?id=70433
--- Comment #6 from [email protected] --- (In reply to comment #5) > For clarity, *this* bug is (to the best of my understanding) about the > result of "LIST()" function being recognised as BLOB with internal firedb, > but as varchar (string) using external firedb. When I read the description of Firebird 2.5, I see on p. 166 Result type: BLOB The result is a text BLOB, except when expression is a BLOB of another subtype. Firebird has different sub_types of BLOB. The sub_type of LIST is a text-BLOB > Robert: for "external" firedb, do you use the native connector or something > like ODBC or JDBC? I have tried it with JDBC and ODBC. Both work as expected. > > Robert: try adding the explicit cast to varchar of the result; something > like: > SELECT CAST( LIST("Vorname", ' and ') AS VARCHAR) FROM "Name_VarcharID" Tried this (it's a function implemented in Firebird), but it doesn't work. Gives a firebird_sdbc error. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
