openmrs-distro-referenceapplication icon indicating copy to clipboard operation
openmrs-distro-referenceapplication copied to clipboard

(fix) - O3-3131 use utf8mb4 text encoding for MariaDB to handle all u…

Open chibongho opened this issue 1 year ago • 0 comments

…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.

chibongho avatar Apr 27 '24 02:04 chibongho