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 |
| Reporter | hendrikfreytag | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | not fixable | ||
| Product Version | 4.8.9 / 5.1.9 | ||||
| Target Version | 4.9.6 / 5.2.6 | ||||
| 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. | ||||
| Tags | Search, UTF-8 | ||||
| Theme | All | ||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
|
|
Demoshops are now utf8, so you can reproduce it there. http://demoshop.oxid-esales.com/professional-edition |
|
|
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. |
