<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FIREBIRD: Query with LIKE doesn't work with special characters"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126262">126262</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FIREBIRD: Query with LIKE doesn't work with special characters
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>robert@familiegrosskopf.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=152611" name="attach_152611" title="Try the query with a special character - won't work">attachment 152611</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=152611&action=edit" title="Try the query with a special character - won't work">[details]</a></span>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>