View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0005994||OXID eShop (all versions)||1.06. Search, Tags||public||2014-12-10 17:46||2015-11-05 17:32|
|Product Version||4.8.9 / 5.1.9|
|Target Version||4.9.6 / 5.2.6||Fixed in Version|
|Summary||0005994: Searchstring with umlauts gives wrong result in utf8 mode|
|Description||Search for "öl" will also find "chocolate", because it contains "ol".|
|Steps To Reproduce||Search for "Träpez" and "Trapez" in a OXID eShop running in utf8 mode. Both will find e.g. "Trapez ION MADTRIXX".|
|Additional Information||Demoshops are not running in utf8 mode right now, so you can't reproduce it in our demoshops.|
|PHP Version||Not defined|
|MySQL Version||Not defined|
Demoshops are now utf8, so you can reproduce it there.
Using MySQL collation utf8_german2_ci would fix this issue as it is caused by using MySQL search functionality.
It is not possible to fix this bug properly due to missing collation utf8_german2_ci for UTF-8 in MySQL 5.5 and lower (from MySQL v5.6 on collation is available).
A workaround from the code side would mean to risk performance issues e.g. by providing larger SQL queries.
If anyone haa a better idea how to fix this issue please feel free to send us a pull request on GitHub.