Doctrine DBAL

[GH-198] Change default MySQL table collation to utf8_unicode_ci

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 2.3
  • Component/s: None
  • Security Level: All
  • 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.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Benjamin Eberlei added a comment -

A related Github Pull-Request [GH-198] was closed
https://github.com/doctrine/dbal/pull/198

Show
Benjamin Eberlei added a comment - A related Github Pull-Request [GH-198] was closed https://github.com/doctrine/dbal/pull/198
Hide
Permalink
Benjamin Eberlei added a comment -

Merged into 2.3

Show
Benjamin Eberlei added a comment - Merged into 2.3
Hide
Permalink
William Knak added a comment -

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.

Show
William Knak added a comment - 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.

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Benjamin Eberlei
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: