Support

Expand all | Collapse all

MySQL and utf8 vs utf8mb4

  • 1.  MySQL and utf8 vs utf8mb4

    Posted 05-15-2020 09:51
    It's come to my attention that what MySQL (and therefore MariaDB) calls "utf8" is actually "proprietary 3-byte UTF-8", rather than "standard 4-byte UTF-8":

    • https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8.html
    • https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html
    • https://mysqlserverteam.com/mysql-8-0-when-to-use-utf8mb3-over-utf8mb4/
    My questions:
    • Was any testing done with Jama 2015 on MySQL with utf8mb4? Would it have been supported at all, or were we required to use 3-byte utf8 only?
    • Has any testing been with Jama 8 on MySQL with utf8mb4? Is it at all supported?

    We're currently in the midst of migrating from Jama 2015 with MariaDB 10.4.6 and utf8 (i.e. 3-byte) to Jama 8 and MariaDB 10.3, and are wondering if it's recommended / supported to move our character encoding to utf8mb4 while we're at it (since MySQL has deprecated 3-byte utf8 as of MySQL 8).

    Thanks.

    ------------------------------
    Ryan Dill
    ------------------------------


  • 2.  RE: MySQL and utf8 vs utf8mb4

    Posted 05-20-2020 09:23
    Hi Ryan:



    ------------------------------
    Chloe Elliott
    Jama Software
    Portland OR
    ------------------------------



  • 3.  RE: MySQL and utf8 vs utf8mb4

    Posted 06-01-2020 09:09
    Thanks, Chloe. Can you confirm Jama 2015 support for MySQL 5.7?

    https://community.jamasoftware.com/browse/articles/blogviewer?BlogKey=e1c439bf-9643-48e3-8225-81f33e299294 only lists MySQL support for Jama 2015 up to MySQL 5.6.

    ------------------------------
    Ryan Dill
    ------------------------------



  • 4.  RE: MySQL and utf8 vs utf8mb4

    Posted 06-01-2020 12:20
    Ryan:

    The unofficial answer is, the Jama 2015 and MySQL 5.7 will "most probably" work but, it isn't tested and/or supported officially, per the Supported Software document you linked to.

    Hope this helps,

    ------------------------------
    Chloe Elliott
    Jama Software
    Portland OR
    ------------------------------