View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000808 | OXID eShop (all versions) | 4.07. Source code, Test | public | 2009-04-17 11:34 | 2012-12-10 13:45 |
| Reporter | dainius.bigelis | Assigned To | |||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.1.0 revision 17976 | ||||
| Fixed in Version | 4.1.1 revision 18442 | ||||
| Summary | 0000808: Charset changed to UTF8 for database during update to 4.1.0 | ||||
| Description | In the update.sql for updating shop to version 4.1.0 there is one incorrect line: ALTER SCHEMA CHARACTER SET utf8 COLLATE utf8_general_ci; After such update, all elements (Tables, fields), which are created after the update, will have charset UTF8, what's incorrect. This line should not be included in update.sql. | ||||
| Additional Information | Fix which returns database charset to latin1 will be prepared. Fix is needed only for those clients, who already executed the update.sql from UPDATE package (to version 4.1.0) and changed the charset of their DB to UTF8 and don't want to convert shop to UTF8. | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | 5.2.6 | ||||
| Database Version | 5.0.33 | ||||
| related to | 0001970 | closed | dainius.bigelis | Collation problems after update to CE 4.4.0_28699 |
| related to | 0001987 | resolved | vilma_liorensaityte | Collation changes during update from 4.0.0.0 to 4.4.0 |
|
|
The charset of DB can be fixed using this line: ALTER SCHEMA CHARACTER SET latin1 COLLATE latin1_general_ci; Also found two more querries for separate fields, which can be corrupted during executing update.sql and changed DB charset. These can be fixed by running: - for all editions: alter table oxpricealarm modify `OXARTID` char(32) character set latin1 collate latin1_general_ci NOT NULL default ''; - only for EE: alter table oxaddress modify `OXCOUNTRYID` char(32) character set latin1 collate latin1_general_ci NOT NULL; all these fixes are collected to one script (different for each edition) and published separately. |
