[Libreoffice-bugs] [Bug 126262] New: FIREBIRD: Query with LIKE doesn't work with special characters

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126262
           Summary: FIREBIRD: Query with LIKE doesn't work with special
                    characters
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

Created attachment 152611
  --> https://bugs.documentfoundation.org/attachment.cgi?id=152611&action=edit
Try the query with a special character - won't work

Open the attached database.
open the query.
Input 'e' as parameter.
Query will work.
Now input something like 'ä' or 'ö' or some special characters of your
language.
The query won't work.
An error appears:
*Malformed String

This is the query:
SELECT "ID", "Forename", "Surname" FROM "Table1" WHERE "ID" LIKE '%' || :search
|| '%' OR "Forename" LIKE '%' || :search || '%' OR "Surname" LIKE '%' ||
:search || '%'
Field "ID" is INTEGER. Without searching "ID" it will work. LIKE works with
every field-type (DATE, number-fields ...) if the content hasn't special
characters. LIKE won't work with special characters in filed-types, which
aren't fields for characters.
Queries like the query above will work well in internal HSQLDB with special
characters.

My system: LO 6.2.5.2 on OpenSUSE 15 64bit rpm Linux

-- 
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/20190707/207c9eca/attachment-0001.html>