BryanDavis has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/370143 )

Change subject: Change default mysql collation to utf8mb4_unicode_ci
......................................................................


Change default mysql collation to utf8mb4_unicode_ci

If you use a case-sensitive encoding in your mysql tables, Django's ORM
will never be able to do a case-insensitive lookup. Conversely Django
will automatically add a 'BINARY' modifier when generating SQL for for
a search that is not explictly marked as case-insensitive. See some
details at https://code.djangoproject.com/ticket/9682

Change-Id: Ie4adda483407baa9eda9cbee605b029bdc83bccb
---
M striker/settings.py
1 file changed, 1 insertion(+), 1 deletion(-)

Approvals:
  BryanDavis: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/striker/settings.py b/striker/settings.py
index 584d957..87fb1d7 100644
--- a/striker/settings.py
+++ b/striker/settings.py
@@ -228,7 +228,7 @@
         'charset': 'utf8mb4',
         'init_command':
             'SET character_set_connection=utf8mb4,'
-            'collation_connection=utf8mb4_bin;'
+            'collation_connection=utf8mb4_unicode_ci;'
             'SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED',
     }
 

-- 
To view, visit https://gerrit.wikimedia.org/r/370143
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: Ie4adda483407baa9eda9cbee605b029bdc83bccb
Gerrit-PatchSet: 3
Gerrit-Project: labs/striker
Gerrit-Branch: master
Gerrit-Owner: BryanDavis <bda...@wikimedia.org>
Gerrit-Reviewer: BryanDavis <bda...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to