[Libreoffice-bugs] [Bug 123150] FIREBIRD: Query with 'LIKE' fails with error "malformed string", when index is set for the field of the condition of the query

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Mar 28 11:20:53 UTC 2019


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

--- Comment #16 from Gerhard Schaber <gerhard.schaber at gmx.at> ---
You might be right. I tried with FB 3.0.4.

Fails with malformed string:
select * from "table1" where "LastName" LIKE 'Ö%';

Works:
select * from "table1" where "LastName" LIKE UPPER(_iso8859_1 'Ö%');

-- 
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/20190328/70a6d993/attachment.html>


More information about the Libreoffice-bugs mailing list