Issue Bug Closed

#15020mysql like regarding german "umlaute"

Nikolas Hagelstein 10/10/05, 00:01 updated 11/10/15, 10:37

Description

when performing a like search on index_search.baseword containing a special character like an german “umlaut” e.g.“ß“
mysql returns
“schloß“
but also
“schloss”

this is because mysql reduces characters to its “basecharater” unless the db field is flagged as binary.

a resultrow containing basecharactered word instead of the orignal search word makes indexedsearch fail on rendering the preview/highlight-searchword stuff.

quick n dirty workaround is to set index_search.baseword to binary.

(issue imported from #M1561)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.