PhixFlow stores its data in a database. The recommended database configurations, described on the Database page, mean your instance of PhixFlow can store UTF8 characters in its database. However, the different databases handle characters from the extended set 4-bit characters (such as emojis) differently.
| Database | Behaviour |
|---|---|
| Oracle | Stores extended 4-bit characters correctly. |
| SQL Server | Discards or converts extended characters4-bitcharacters. |
| MariaDB | Fails to store extended 4-bit characters because it only recognises a sub-set of UTF8 (UTF8mb3/UTF8mb4). This can cause problems if data contains 4-bit characters, such as emojis. |
If you are loading data from another database, a file or emails, you will need to either escape or remove any invalid characters before writing to PhixFlow running on MariaDB.
...