I use utf8 for "normal" field like name, address, etc.. (don't want smiley as first name). And use utf8mb4 for comment for example. But I need filter/validate each inputs (and refuse when there is 4 bytes characters).
I did a project with postgres and symfony+doctrine. At 80% of completion, I moved to mySql because I needed spatial index, I installed Postgis but got a lot of problems with doctrine-migration.
The main reason I don't use mariaDb is the non support of nullable spatial index. https://mariadb.com/kb/en/library/spatial-index/
I use utf8 for "normal" field like name, address, etc.. (don't want smiley as first name). And use utf8mb4 for comment for example. But I need filter/validate each inputs (and refuse when there is 4 bytes characters).
I did a project with postgres and symfony+doctrine. At 80% of completion, I moved to mySql because I needed spatial index, I installed Postgis but got a lot of problems with doctrine-migration.
The main reason I don't use mariaDb is the non support of nullable spatial index. https://mariadb.com/kb/en/library/spatial-index/