Skip to content


DBAL-342: [GH-198] Change default MySQL table collation to utf8_unicode_ci #1529

doctrinebot opened this Issue · 5 comments

2 participants


Jira issue originally created by user @beberlei:

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

Url: #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 created by @beberlei:

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


Comment created by @beberlei:

Merged into 2.3


Issue was closed with resolution "Fixed"


Comment created by williamk:

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 "utf8unicodeci" instead of our database default collate.


Comment created by @doctrinebot:

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

@doctrinebot doctrinebot added the Bug label
@beberlei beberlei was assigned by doctrinebot
@doctrinebot doctrinebot added this to the 2.3 milestone
@doctrinebot doctrinebot closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.