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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
