I would like to use utf8_unicode_ci collation is this safe in Drupal 7 (default is utf8_general_ci)? How to set utf8_unicode_ci collation? Do I need to edit settings.php or something?

CommentFileSizeAuthor
#4 utf-8 collation-screenshot.png83.72 KBMohanavel
#3 Screenshot from 2015-12-07 16:05:28.png57.38 KBsumit.prajapati

Comments

kelutrab11 created an issue. See original summary.

cilefen’s picture

cilefen commented
Title: drupal 7 utf8_unicode_ci db » How to set utf8_unicode_ci collation
sumit.prajapati’s picture

sumit.prajapati commented
StatusFileSize
new Screenshot from 2015-12-07 16:05:28.png57.38 KB

Its depends on your needs. Go to your Database, click on operation tab and change collation you want then Click on go button as shown in image.

Mohanavel’s picture

Mohanavel commented
StatusFileSize
new utf-8 collation-screenshot.png83.72 KB

utf8_general_ci is enough for a drupal project, it is very important for multilanguage concept. You can easily make change the collation by selecting from the collation dropdown.

Version: 7.39 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.

Status: Active » Closed (outdated)

Automatically closed because Drupal 7 security and bugfix support has ended as of 5 January 2025. If the issue verifiably applies to later versions, please reopen with details and update the version.