https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #30 from Commit Notification
---
Tamas Bunth committed a patch related to this issue.
It has been pushed to "libreoffice-6-2":
https://git.libreoffice.org/core/+/3173e00f428ea8cf79f36efb38d15028aca01d4a%5E%21
tdf#123150: Fi
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Commit Notification changed:
What|Removed |Added
Whiteboard|target:6.4.0 target:6.3.0.2 |target:6.4.0 target:6.3.0.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Xisco Faulí changed:
What|Removed |Added
Status|RESOLVED|VERIFIED
--- Comment #29 from Xisc
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #28 from Gerhard Schaber ---
Works now. Tested on Windows with manually executed statements and filters,
both with a new and an existing database.
Version: 6.4.0.0.alpha0+ (x86)
Build ID: c738be4de6886a0c96b7d10df7e78c8b2964c
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Adolfo Jayme changed:
What|Removed |Added
Resolution|--- |FIXED
Status|NEW
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Xisco Faulí changed:
What|Removed |Added
CC||xiscofa...@libreoffice.org
--- Com
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #26 from Gerhard Schaber ---
Thanks for putting this into 6.3. There has not been a master build with the
changes, so I have not been able to test it, yet.
--
You are receiving this mail because:
You are the assignee for the
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #25 from Commit Notification
---
Tamas Bunth committed a patch related to this issue.
It has been pushed to "libreoffice-6-3":
https://git.libreoffice.org/core/+/4897c78c4b0ce88b65d509066990bdf5ae444d9a%5E%21
tdf#123150: Fi
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Commit Notification changed:
What|Removed |Added
Whiteboard|target:6.4.0|target:6.4.0 target:6.3.0.2
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #24 from Gerhard Schaber ---
Great finding. Thanks. I will give it a try.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #23 from Tamas Bunth ---
Gerhard, could you please verify, that the issue is fixed now?
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bug
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #22 from Commit Notification
---
Tamas Bunth committed a patch related to this issue.
It has been pushed to "master":
https://git.libreoffice.org/core/+/c19c206cf42ac178906a855ae3cd198e0fcf8d14%5E%21
tdf#123150: Firebird: s
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Commit Notification changed:
What|Removed |Added
Whiteboard||target:6.4.0
--
You are r
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #21 from Tamas Bunth ---
We need to specify the character set of the connection between the server and
the sdbc driver too.
This can be done using the isc_dpb_lc_ctype DPB parameter option as documented
in the Interbase API r
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #20 from Gerhard Schaber ---
If that is not fixed in Firebird, can LibreOffice do the conversion of the
literal for a LIKE clause to the configured character set?
--
You are receiving this mail because:
You are the assignee
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Roman Kuznetsov <79045_79...@mail.ru> changed:
What|Removed |Added
Blocks||51780
Re
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #19 from Gerhard Schaber ---
I guess, even in the case this is really an issue in Firebird and there is no
fix on that side (I cannot assess this from user perspective), LO itself should
have a fix to make it work for the end
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #18 from Gerhard Schaber ---
Also, it is not possible to filter for a name starting with 'Ö' in a table
using LIKE.
--
You are receiving this mail because:
You are the assignee for the bug.___
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #17 from Gerhard Schaber ---
This one seems to fix the issue when executing the SQL statement in LO:
select * from "table1" where "LastName" LIKE _utf8 'Ö%';
Apparently one has to specify the character set. That was definitel
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #16 from Gerhard Schaber ---
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 'Ö%
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #15 from Lionel Elie Mamane ---
This smells like a Firebird bug. Do you get the same situation when using
Firebird directly, not through LibreOffice?
--
You are receiving this mail because:
You are the assignee for the bug._
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #14 from Gerhard Schaber ---
Created attachment 150341
--> https://bugs.documentfoundation.org/attachment.cgi?id=150341&action=edit
Minimal test file
Here a simpler example (likeumlaut.odb). That is a most basic table with
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #13 from Gerhard Schaber ---
Is there at least a workaround for that (that does not require UPPER everywhere
where LIKE is used)?
--
You are receiving this mail because:
You are the assignee for the bug._
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #12 from Gerhard Schaber ---
Nah, sorry, that is because of the UNICODE_CI_AI.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #11 from Gerhard Schaber ---
BTW, I just realized that using UPPER is no workaround. It makes an O out of
the Ö.
--
You are receiving this mail because:
You are the assignee for the bug.__
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Alex Thurgood changed:
What|Removed |Added
CC||btom...@gmail.com,
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Robert Großkopf changed:
What|Removed |Added
Summary|FIREBIRD: Simple SQL query |FIREBIRD: Query with 'LIKE'
27 matches
Mail list logo