View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007709 | OXID eShop (all versions) | 4.06. Language and translations | public | 2024-08-23 16:47 | 2024-09-11 12:27 |
| Reporter | VP | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | confirmed | Resolution | open | ||
| Product Version | 7.1.0 | ||||
| Summary | 0007709: Translation columns in _set tables has wrong collation | ||||
| Description | In the main tables the columns which can be translated (for example OXTITLE and OXTITLE_1) have the collation utf8_general_ci, but in the _set tables for multiple languages these columns have latin1_general_ci by default. To be found in DbMetaDataHandler.php in line 229. This means that in some languages the value entered in the administration is saved as “?????” and are not usable. For example, for Russian. | ||||
| Steps To Reproduce | Add languages in the administration until the _set tables are created and then for example go to any list (for example: attributes, articles etc.) and try saving an entry with "special" characters like russian for example. | ||||
| Additional Information | vendor/oxid-esales/oxideshop-ce/source/Core/DbMetaDataHandler.php line 229 | ||||
| Tags | Collation, Database, Internationalization Rework, Languages | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
