[DBAL-342] [GH-198] Change default MySQL table collation to utf8_unicode_ci Created: 14/Sep/12 Updated: 12/Nov/12 Resolved: 17/Sep/12 |
|
| Status: | Resolved |
| Project: | Doctrine DBAL |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 2.3 |
| Security Level: | All |
| Type: | Bug | Priority: | Major |
| Reporter: | Benjamin Eberlei | Assignee: | Benjamin Eberlei |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
This issue is created automatically through a Github pull request on behalf of VladanStef: Url: https://github.com/doctrine/dbal/pull/198 Message: I think default table collation should be changed to `utf8_unicode_ci`, as it handles properly a much wider array of characters (Cyrillic, for example) at a generally negligible cost of performance. `utf8_general_ci` simply does not work properly with too many languages and should be avoided as a default. |
| Comments |
| Comment by Benjamin Eberlei [ 17/Sep/12 ] |
|
A related Github Pull-Request [GH-198] was closed |
| Comment by Benjamin Eberlei [ 17/Sep/12 ] |
|
Merged into 2.3 |
| Comment by William Knak [ 12/Nov/12 ] |
|
What about leaving default collate empty? So it will inherit database default collation / charset. I've just created a ticket suggesting that # |