openmrs-distro-referenceapplication
openmrs-distro-referenceapplication copied to clipboard
(fix) - O3-3131 use utf8mb4 text encoding for MariaDB to handle all u…
…tf8 characters
The Refapp currently uses MariaDB as its database, with utf8 as its default text encoding. However, MariaDB’s implementation of utf8 cannot handle all utf8 characters (for example: emojis). This PR changes it to use utf8mb4, which should handle all utf8 characters.
Testing done:
- Tried creating an appointment with appointment notes with emojis included. This currently fails in dev3, but passes in my local refapp instance with this change.