Add a collation reproducing the pre-5.1.24 behavior of utf8_general_ci and ucs2_general_ci to Percona Server 5.1
Fix for MySQL bug http://
1. any indexes on columns defined with those collations and containing ß must be rebuilt after upgrading from 5.0 or 5.1.23 or lower
2. unique constrains may get broken after upgrade due to possible duplicates.
There is a proposed patch in http://
That patch, however, has not been merged to any MySQL trees at the moment of this writing. It is also unclear whether there are any plans to merge it.
This blueprint is to port collations from that patch, possibly under different names, because "german" looks confusing to many people storing values not necessarily specific to the German language in utf8_general_ci columns before an upgrade, so questions about the naming are quite frequent.
The proposed new names are utf8_general50_ci and ucs2_general50_ci.
References:
http://
http://
http://
Blueprint information
- Status:
- Complete
- Approver:
- Stewart Smith
- Priority:
- Undefined
- Drafter:
- Alexey Kopytov
- Direction:
- Needs approval
- Assignee:
- Alexey Kopytov
- Definition:
- Approved
- Series goal:
- Accepted for 5.1
- Implementation:
- Implemented
- Milestone target:
- 5.1.58-12.9
- Started by
- Alexey Kopytov
- Completed by
- Alexey Kopytov