[Koha-bugs] [Bug 20689] Make it possible to add capital letter subfields to item search fields

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20689 --- Comment #45 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Fridolin Somers from comment #40)

(In reply to Nick Clemens from comment #39)

...

We need to figure a method to make the query case sensitive

Looks like we can set COLLATE like : select city_name from cities where city_name='Paris' COLLATE utf8mb4_bin;

I believe that is not quite the solution yet, as it would affect the strings we compare to instead of only the subfield codes, as we intend. -- You are receiving this mail because: You are watching all bug changes.