/lagotto

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migrate MySQL from utf8 to utf8mb4 to support emojis #324

Closed
mfenner opened this Issue Jun 11, 2015 · 0 comments

Comments

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
1 participant
@mfenner
@mfenner
Member

mfenner commented Jun 11, 2015

This is relevant for the works.title, deposits.message and alerts.message columns. Emojis are mostly found in tweets and are currently resulting in MySQL errors.

mfenner pushed a commit that referenced this issue Jun 11, 2015

Martin Fenner
only change affected fields to utf8mb. #324
b67c1df

mfenner pushed a commit that referenced this issue Jun 11, 2015

Martin Fenner
tweaks in the db migrations for utf8mb4. #324
479c6f3

mfenner pushed a commit that referenced this issue Jun 11, 2015

Martin Fenner
comment out utf8 encoding migration, as we do this manually for now. #… 
…324
be0d71c

mfenner pushed a commit that referenced this issue Jun 11, 2015

Martin Fenner
upgrade to mysql2 gem 0.3.18. #324
4f5f81a

mfenner pushed a commit that referenced this issue Jun 11, 2015

Martin Fenner
run utf8mb4 migrations. #324
c7c2dae

mfenner pushed a commit that referenced this issue Jun 11, 2015

Martin Fenner
temporarily disable migrations to utf8mb4. #324
d57fc0c

mfenner pushed a commit that referenced this issue Jun 12, 2015

Martin Fenner
use demoji gem as temporary workaround for utf8 issues. #324
fe71be5

mfenner pushed a commit that referenced this issue Jun 12, 2015

Martin Fenner
added another column that needs to b ein utf8mb4 format. #324
1be1d94

mfenner pushed a commit that referenced this issue Jun 14, 2015

Martin Fenner
use utf8mb4 encoding. #324
2b5f0bc

mfenner pushed a commit that referenced this issue Jun 14, 2015

Martin Fenner
changed order of migrations needed for utf8mb. #324
b910da5

mfenner pushed a commit that referenced this issue Jun 14, 2015

Martin Fenner
define some columns as mediumtext. #324
1e38f5e

mfenner pushed a commit that referenced this issue Jun 14, 2015

Martin Fenner
change column size. #324
92939d6

mfenner pushed a commit that referenced this issue Jun 14, 2015

Martin Fenner
use mediumtext for details column. #324
ed4596f

@mfenner mfenner closed this in daa29dd Jun 14, 2015

mfenner pushed a commit that referenced this issue Jun 14, 2015

Martin Fenner
change migrations to support utf8mb4. #324
239388a

mfenner pushed a commit that referenced this issue Jun 15, 2015

Martin Fenner
use demoji gem to strip emoji characters as workaround. #324
5dfb8f5

mfenner pushed a commit that referenced this issue Jun 26, 2015

Martin Fenner
removed demoji gem. #324
7782d13

mfenner pushed a commit that referenced this issue Jul 8, 2015

Martin Fenner
change default encoding to utf8mb4. #324
ceb58a6

mfenner pushed a commit that referenced this issue Jul 8, 2015

Martin Fenner
change some columns and indexes to utf8mb4. #324
a41be15

mfenner added a commit that referenced this issue Jan 4, 2016

@mfenner
turn deposits/message column into utf8mb4. #324
02c2017

mfenner added a commit that referenced this issue Jan 4, 2016

@mfenner
change utf8 encoding of another row. #324
631b797

mfenner added a commit that referenced this issue Jan 4, 2016

@mfenner
change another column to utf8mb4. #324
f747875

mfenner added a commit that referenced this issue Jan 4, 2016

@mfenner
more utf8mb4 changes. #324.
71b8894

mfenner added a commit that referenced this issue Jan 4, 2016

@mfenner
fix utf8mb encoding. #324
7057f11
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment