[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


 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
https://github.com/doctrine/dbal/pull/198

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:
https://github.com/doctrine/common/pull/198

Generated at Sun Oct 26 07:44:41 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.