search

a-thousand-channels / ORTE-backend

Application for creating and managing places (or "Orte") on a map
GNU General Public License v3.0
2 stars 3 forks source link

Convert Database to utf8mb #331

Open ut opened 3 months ago

ut commented 3 months ago

...to allow to store 4byte UTF8 characters, like emojis. U+01F4A9 Pile of Poo (💩).

ut commented 3 months ago

A conversion must be done on the datebase metadata plus on all text fields. A subsequent problem is that a conversion would shorten text fields (255 chars) so before a conversion we need to check if a cropping would occur on the live database.