[DBAL-342] [GH-198] Change default MySQL table collation to utf8_unicode_ci Created: 14/Sep/12  Updated: 03/Dec/13  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


This issue is created automatically through a Github pull request on behalf of VladanStef:

Url: https://github.com/doctrine/dbal/pull/198


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.

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 #DDC-2139 . Because we're experiencing trouble using Symfony2 commands to create database, than create schema/tables/fields, always use "utf8_unicode_ci" instead of our database default collate.

Comment by Doctrine Bot [ 03/Dec/13 ]

A related Github Pull-Request [GH-198] was closed:

Generated at Tue Dec 01 22:30:05 EST 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.