From 9fc885d69678151361f22532f757f6804cbf59f5 Mon Sep 17 00:00:00 2001 From: Jan-Pascal van Best Date: Mon, 22 Feb 2016 20:29:05 +0100 Subject: [PATCH] Fix database character set: utf8mb4 to allow emoji in tweet texts --- .../0011_change_database_charset.py | 20 +++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 tweet/migrations/0011_change_database_charset.py diff --git a/tweet/migrations/0011_change_database_charset.py b/tweet/migrations/0011_change_database_charset.py new file mode 100644 index 0000000..a32031e --- /dev/null +++ b/tweet/migrations/0011_change_database_charset.py @@ -0,0 +1,20 @@ +# -*- coding: utf-8 -*- +from __future__ import unicode_literals + +from django.db import migrations, models +import django.utils.timezone + + +class Migration(migrations.Migration): + + dependencies = [ + ('tweet', '0010_auto_20160220_2130'), + ] + + operations = [ + migrations.RunSQL("ALTER DATABASE DEFAULT CHARACTER SET utf8mb4"), + migrations.RunSQL("ALTER TABLE tweet CHARACTER SET utf8mb4"), + migrations.RunSQL("ALTER TABLE tweet MODIFY text LONGTEXT CHARACTER SET utf8mb4") + ] + + -- 2.39.5