MySQL should use utf8mb4 instead of utf8

[thomaschaaf]

Describe the bug
Currently you can not save emojis in the database with the default encoding setting.

Here is a blog post about it:
https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434

[B4nan]

There is no diffing support for this (and I am not planning to add it), so you can just change it manually on existing tables.

[thomaschaaf]

But could the default be changed? I bet a lot of people don't know why saving emojis won't work for them. It would just have to be changed here right?

mikro-orm/lib/schema/MySqlSchemaHelper.ts

Lines 38 to 47 in c36b495

	return 'set names utf8;\nset foreign_key_checks = 0;\n\n';
	}
	getSchemaEnd(): string {
	return 'set foreign_key_checks = 1;\n';
	}
	finalizeTable(table: CreateTableBuilder): void {
	table.engine('InnoDB');
	table.charset('utf8');

[B4nan]

Only thing that makes sense to change is the finalizeTable part. Sure we can make this configurable.