https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Bug ID: 123150
Summary: Simple SQL query fails with error "malformed string"
Product: LibreOffice
Version: 6.2.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: gerhard.scha...@gmx.at
Created attachment 148877
--> https://bugs.documentfoundation.org/attachment.cgi?id=148877&action=edit
Test file
A simple SQL select fails depending on the search string. I am using the
following query with the attached testquery.odb file:
select * from "MitgliederVerband" where "Vorname" LIKE 'Ötkül%'
This is the error I get:
1: firebird_sdbc error:
*Malformed string
caused by
'SELECT * FROM "MitgliederVerband" WHERE "Vorname" LIKE 'Ötkül%''
The same happens when I run the query via Basic macro.
Note that I have applied collation settings to the DB, so that I can run case
insensitive queries. That query has been working for quite some time. The name
Ötkül is the first name I came across that it does not seem to handle very
well. I can store that name in the DB, but I cannot search for it, not even if
the DB is empty.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs