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

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20689

--- Comment #45 from Katrin Fischer <katrin.fischer at 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.